Returns the number of the ISO week of the year (1 to 53) for the specified date. If the date is not valid, 0
is returned.
Sample usage
ISOWEEKNUM("1/1/2021")
returns 53
ISOWEEKNUM("1/4/2021")
returns 1
ISOWEEKNUM(TODAY())
returns today's ISO week number. See also TODAY()
Syntax
ISOWEEKNUM(date)
date
- Textual value (in quotes) or expression that resolves to aDate
orDateTime
value.
Note
Some constant values, such as "MM/DD/YYYY"
, are evaluated as a Date
value by AppSheet. Similarly, "000:00:00"
is evaluated as a Duration
value. This doesn't mean your spreadsheet data must use the same formats: the date and time formats in your spreadsheets are determined by the locale/language setting. Column will always be evaluated as the type of column. Additionally, you can convert data, both columns and string literals, to specific types using functions such as DATE()
, TIME()
, or DATETIME()
.