DAY
Returns the day of the month from a date.
How it’s written
DAY(date)Example
| A | |
|---|---|
| 1 | Date |
| 2 | 46,096 |
=DAY(A2)Result: 15
The date is the 15th.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
For a weekday instead, use WEEKDAY.
Practice it properly
Taking dates apart gives you real tasks, with your formulas tested on data you haven’t seen.