Returns a number that indicates where the week falls numerically within a year.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Syntax
WEEKNUM(serial_num,return_type)
Serial_num is a date within the week.
Return_type is a number that determines on what day the week begins. The default is 1.
|
Serial num |
Week Begins |
|
1 |
Week begins on Sunday. Weekdays are numbered 1 through 7. |
|
2 |
Week begins on Monday. Weekdays are numbered 1 through 7. |
Examples
If date is Sunday, January 9, 1994, then:
WEEKNUM("1/9/94", 1) equals 3
WEEKNUM("1/9/94", 2) equals 2