MONTH Function
Purpose
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Syntax
EXCEL
=MONTH(serial_number)
Arguments Breakdown
| Argument | Required? | Description |
|---|---|---|
serial_number |
Required | The date of the month you are trying to find. |
Practical Examples
1. Extract Month Component Drill
From Formulas_&_Functions_Part_2.xlsx (Sheet Date and Time ):
EXCEL
=MONTH(TODAY())
Returns month integer (e.g. 9 for September).
2. Quarterly Partitioning
EXCEL
=ROUNDUP(MONTH(A2) / 3, 0)
Converts month index (1-12) to Quarter index (Q1, Q2, Q3, Q4).
Related Knowledge
- Notes: 06 Date and Time Intelligence
- Workbook:
11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_2.xlsx(Sheet:Date and Time)