DAY pulls the day-of-month out of a date: given 2026-11-16 it returns 16. It reads an Excel date serial and returns a number 1–31, correctly handling month ends and leap days. Use it for day-based grouping, deadlines and date labels.
Returns a number 1–31. The day of the month of the given date.
The day-of-month, isolated. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =DAY(C2) | 16 | Day of 2026-11-16 |
| =DAY(C3) | 1 | First of the month |
| =DAY(C5) | 31 | Last day of December |
| =DAY(C8) | 29 | Leap day 2024-02-29 |
| =DAY(DATE(2026,11,16)) | 16 | From a constructed date |
| =DAY(C2)&"/"&MONTH(C2)&"/"&YEAR(C2) | 16/11/2026 | Day-first date label |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to extract the day from a date.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
DAY is a core date function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
DAY is one piece. The full course walks the toolkit end to end with live, measured examples.