DAY function
DAY pulls the day of the month, from 1 to 31, out of a date. It is often paired with MONTH and YEAR when splitting or regrouping dates.
Example
Read it as a sentence: turn 2024, 3, 15 into a date, then pull out the day of the month, which gives 15.
A
B
C
D
1
15
2
3
Syntax
DAY(serial_number)
-
serial_number(required) - A date or date serial number.
Returns: The day of the month, 1 to 31.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DAY(46031) | 9 | Serial |
=DAY("1/9/2026") | 9 | Text date |
=DAY(0) | 0 | Serial 0 |
=DAY(60) | 29 | Serial 60 (1900-02-29) |
=DAY(46031.9) | 9 | Fractional serial |
=DAY(2958465) | 31 | 9999-12-31 |
=DAY(-1) | #NUM! | Negative serial |
=DAY(2958466) | #NUM! | Past 9999-12-31 |
Watch out for
- Text that looks like a date is accepted but depends on regional settings.
- Not the day of the week; use WEEKDAY for that.
Where it works
- Excel
- DAY is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .