ISOWEEKNUM()

Number of the ISO week of the year for the specified date

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 a Date or DateTime value.

See also

Date and time expressions

EOMONTH()

WEEKDAY()

WEEKNUM()

WORKDAY()

Was this helpful?
How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
false
false