Better Sheets

How to Use DAY() in Google Sheets

Description

Returns the day of the month that a specific date falls on, in numeric format.

How To Actually Use DAY() in Sheets

DAY(date)

In cells B1:B10, enter dates. Use the DAY() formula in cells C1:C10 to extract the day of the month from each date in column B.

Your formula

Hints (2)

Locale Separator ,

Better Sheets Tutorial

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

Transcript-matched member videos for DAY(). Click through to watch.

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Learn more about the DAY() formula:

Generate a DAY() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DAY(). 2 free AI generations, no signup. Members get unlimited use.

More related tutorials