Formulas > =DAY()
How To Use DAY() Function in Google Sheets
Description
How To Actually Use DAY() in Sheets
DAY(date)
Try DAY yourself
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.
Hints (2)
-
Remember to reference the correct cell for the date.
-
You can drag the formula down to fill the other cells.
1 Better Sheets Tutorial
Can I Automatically Rename a Sheet based on a Date?
Change the title of a spreadsheet from within a cell in the spreadsheet.
DAY()
MONTH()
TODAY()
YEAR()
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.
Generate a DAY() formula