DAY Function
Returns the day of the month from a date.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A number from 1 to 31
Overview
DAY reads a date and returns its day of the month, from 1 to 31.
Pair it with MONTH and YEAR to take a date apart, or with DATE to rebuild it with one part changed.
Syntax
=DAY(serial_number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | The date — a cell, a DATE formula or a date serial number. |
Examples
Example 1 — Day of each order
Pull the day out of Northstar's order dates.
B2fx=DAY(A2)
| A | B | |
|---|---|---|
| 1 | Order date | Day |
| 2 | 3/15/2026 | 15 |
| 3 | 7/4/2026 | 4 |
| 4 | 12/31/2026 | 31 |
=DAY(A2) Explain
Example 2 — Flag orders in the first half of the month
Combine DAY with IF.
=IF(DAY(A2)<=15, "1st half", "2nd half") Explain
Common mistakes
- DAY returns 0. The cell is empty (an empty cell counts as day 0 of January 1900). Check the reference.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.