Date & Time
Modern
DAY
Extracts the day of the month (1–31) from a date.
Available in All versions
Syntax
DAY(serial_number)What it returns
The day of the month, 1 to 31.
Arguments
| Argument | Required | Description |
|---|---|---|
serial_number |
Yes | The date to read the day from. |
Example
| A | |
|---|---|
| 1 | Date |
| 2 | 06/11/2026 |
Result
11
DAY reads the day of the month out of a date (11).
=DAY(A2)Important to know
Returns the day of the month, not the weekday — use WEEKDAY for the weekday.
Input must be a valid Excel date.