MONTH
Returns the month of a date, as a number.
How it’s written
MONTH(date)Example
| A | |
|---|---|
| 1 | Date |
| 2 | 46,096 |
=MONTH(A2)Result: 3
The date is in March.
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 month name, use TEXT(A2,"mmmm").
Practice it properly
Taking dates apart gives you real tasks, with your formulas tested on data you haven’t seen.