Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DAY
DAY returns the numeric day of the month from a given date serial number or date text string. It is commonly used to determine billing cycles, identify end-of-month records, or decompose dates into their components for custom formatting.
Excel
=DAY(DATE(2024,6,15))Google Sheets
=DAY(DATE(2024,6,15))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| InvoiceDate | DayNum |
| 2024-03-05 | |
| 2024-07-19 | |
| 2024-11-01 | |
| 2024-12-31 |
=DAY(DATE(2024,6,15))→15
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Make sure your date column contains real date values, not text.
- 2In an adjacent cell enter =DAY(A2) to extract the numeric day.
- 3Combine DAY with MONTH and YEAR if you need to reconstruct or compare partial dates.