Google Sheets
DAY function in Google Sheets
Returns the day of the month that a specific date falls on, in numeric format.
=DAY(date)DAY syntax and parameters
One argument, one required.
- dateanyRequired
The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.
DAY examples
Formulas you'll actually reuse.
The day of the month from an invoice date:
=DAY(B2)Result
14How many days the invoice's month has:
=DAY(EOMONTH(B2, 0))Result
31
DAY in Excel
Same name — your formula ports as-is.
Try DAY in the playground
Edit the example — nothing to install.
Preloaded with the DAY formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- DATEConverts a provided year, month, and day into a date.DateExcel
- DATEDIFCalculates the number of days, months, or years between two dates.DateExcel
- DATEVALUEConverts a provided date string in a known format to a date value.DateExcel
- DAYSReturns the number of days between two dates.DateExcel
- DAYS360Returns the difference between two days based on the 360 day year used in some financial interest calculations.DateExcel
- EDATEReturns a date a specified number of months before or after another date.DateExcel