WEEKNUM()

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

See Also

EOMONTH()

ISOWEEKNUM()

WEEKDAY()

WORKDAY()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false