WEEKNUM

Returns the week of the year for a date, so 15 December 2024 is week 51.

When to use

It sits beside WEEKDAY in the Lec 04 date-function sheet; use it when a question asks which week of the year a date falls in.

See Lec 04.

Appears in

No references yet.