Week of year from Date or DateTime
Returns the week of the year as a Number
(1
to 53
) if date is recognized, or 0
if not.
Sample usage
WEEKNUM("1/1/2019")
returns 1
WEEKNUM("12/31/2019")
returns53
WEEKNUM(TODAY())
returns Today's week number.
Syntax
WEEKNUM(when)
when
- 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()
.