The MONTH function
Returns the month of a date as a number from 1 (January) to 12 (December).
Syntax
MONTH(serial_number)- serial_number
- The date.
Examples
C1=MONTH(A2)
| A | B | C | |
|---|---|---|---|
| 1 | Date | 3 | |
| 2 | 45366 |
C1=MONTH(DATE(2025,1,31))
| A | B | C | |
|---|---|---|---|
| 1 | Date | 1 | |
| 2 | 45366 |
Returns the month of a date as a number from 1 (January) to 12 (December).
MONTH(serial_number)| A | B | C | |
|---|---|---|---|
| 1 | Date | 3 | |
| 2 | 45366 |
| A | B | C | |
|---|---|---|---|
| 1 | Date | 1 | |
| 2 | 45366 |