DAY
Converts a serial number to a day of the month.
Date & TimeDates & Time CalculationsMost Used
What it does
Returns the day of the month (1–31) from a date.
Syntax
DAY(serial_number)
Arguments
serial_number(date) — Date to extract from.
Examples
Extract day
Get the day from A2.
FORMULA
=DAY(A2)
RESULT
15
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-03-15 |
| 3 | 2025-12-31 |