ISOWEEKNUM
Returns the number of the ISO week number of the year for a given date.
Date & TimeDates & Time Calculations
What it does
Returns the ISO 8601 week number (1-53).
Syntax
ISOWEEKNUM(date)
Arguments
date(date) — Date.
Examples
ISO Week
Week for Jan 8, 2021.
FORMULA
=ISOWEEKNUM("2021-01-08")RESULT
1
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2021-01-08 |