Excel
DAY function in Excel
Converts a serial number to a day of the month
=DAY(serial_number)DAY syntax and parameters
One argument, one required.
- serial_numbernumberRequired
The date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
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 Google Sheets
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 Excel gets this done.
- DATEReturns the serial number of a particular dateDateGoogle Sheets
- DATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DateGoogle Sheets
- DATEVALUEConverts a date in the form of text to a serial numberDateGoogle Sheets
- DAYSReturns the number of days between two datesDateGoogle Sheets
- DAYS360Calculates the number of days between two dates based on a 360-day yearDateGoogle Sheets
- EDATEReturns the serial number of the date that is the indicated number of months before or after the start dateDateGoogle Sheets