ISOWEEKNUM
Description
Returns an integer from 1 to 53 representing the ISO week number of the specified
date.
Each week of the International Organization for Standardization (ISO) date system
starts on a Monday; week number 1 is the first week of the year that contains a
Thursday. For more information, see
Wikipedia ISO Week Date
.
Syntax
ISOWEEKNUM(
date
)
- date: The date to get the week value from. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
Example
Formula | Result |
|---|---|
=ISOWEEKNUM("6-May-2016") | 18 |
=ISOWEEKNUM("6-Dec-2016") | 49 |