WEEKNUM()

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") returns 53

WEEKNUM(TODAY())  returns Today's week number.

Syntax

WEEKNUM( when )

• when  - A  Date or DateTime  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() . 

See Also

Date and time expressions

EOMONTH()

ISOWEEKNUM()

WEEKDAY()

WORKDAY()