The WEEKNUM
function returns a number that tells you
the week number of the year from 1 to 54.
- The syntax
for the function is WEEKNUM (serial_num,
return_type )
.
The "serial_num"
must be a string or a recognizable
date format in Excel. "return_type" represents
the different methods of referencing
the week of the year.
- Type 1 begins the
week on sunday.
- Type 2 begins the
week on monday.
Each represents
a different way of counting weeks. For
example:
WEEKNUM ("1/7/2007",1) = 2
and WEEKNUM ("1/7/2007", 2) =
1 The values are different as the date
1/8/2007 is a sunday. Type 1 counts the
beginning of a new week and so is in the
second week but type 2 says that this date
still lies in the first week.
Note: The
WEEKNUM function considered the first week
of the year to be the week containing the
1st of January. This is in contrast to
the European standard that dictates
weeks containing less than three days not
be included as the first week of the year.
|
