Typically the last week number in a year is 53.
However, WEEKNUM will return 54 at the end of some years, like 2000 and 2028.
The WEEKNUM function accepts twoarguments,serial_numandreturn_type.
Theserial_numargument must have avalid Excel date.
Whenreturn_typeis set to 2, week numbers begin on Monday.
Withreturn_type21, week 1 is the week containing the first Thursday of the year, followingISO 8601.
The table below summarizesreturn_typeoptions.
By default,return_typeis 1, and numbers increment on Sunday.
Whenreturn_typeis provided as 2, week numbers begin on Monday.
To create a date from scratch in a formula, it’s possible for you to use theDATE function.
