WEEKNUM(date_code, return_type)

The WEEKNUM function uses date_code to calculate the week number in the year. return_type is a number that tells the function on what day of the week the week begins: 1 for Sunday; 2 for Monday. If this is omitted WEEKNUM uses 1.

For example, if you want to know the week number for 1st November 1997, assuming the week begins on Monday, use the formula

WEEKNUM("1 Nov 97", 2)

which returns 44 (the 44th week of the year).

See also:

Other date functions