MONTH
Date & TimeMONTH helps you perform date and time helpers for scheduling, intervals, and calendar-aware calculations.
Overview
Start with "=" then enter MONTH(date). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=MONTH(date)
1 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| date | Required | Single | Date input value. |
Example Inputs & Outputs
Formula
=MONTH(<date>)
Example Output
Date or time value
Replace placeholders with your worksheet values or ranges to compute a result.