WEEKYEAR
Gets the year for the associated ISO week of the specified date. For more information see ISO Week Date Week Date.
Syntax
=WEEKYEAR(date)
Arguments
| Argument | Type | Description |
|---|---|---|
| date | Date | The date to use for calculation |
Examples
=WEEKYEAR(DATE(2010, 1, 2))→2009
Gets the week-year component 2009 from the specified date Jan 2, 2010 12:00 AM
=WEEKYEAR(DATE(2020, 4, 5, 6, 7))→2020
Gets the week-year component 2020 from the specified date Apr 5, 2020 6:07 AM
Updated 10 months ago