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