WEEKNUM
Category: DateTime Function.
Description: Returns an integer that is the week number of a specified date.
Syntax: WEEKNUM(date_serial_number,[return_type])
Date_serial_number is a serial number representing a date.
Use functions such as DATE to supply an argument to the function.
Return_type is a number that specifies a numbering system to use and a weekday that should be treated as the start of the week.
There are two systems used for this function.
System one defines a week containing January 1 as the first week of the year.
System two defines a week containing the first Thursday of the year as the first week of the year (ISO 8601, European week numbering system).
|
Return_type
|
Week begins on
|
System
|
|
1 or omitted
|
Sunday
|
1
|
|
2
|
Monday
|
1
|
|
11
|
Monday
|
1
|
|
12
|
Tuesday
|
1
|
|
13
|
Wednesday
|
1
|
|
14
|
Thursday
|
1
|
|
15
|
Friday
|
1
|
|
16
|
Saturday
|
1
|
|
17
|
Sunday
|
1
|
|
21
|
Monday
|
2
|