WEEKNUM
Description
Returns an integer from 1 to 53 representing the week number of the specified date.
Syntax
WEEKNUM(
serial_date
, [ return_type
]) - serial_date: The serial number representing the date.
- return_type: The code specifying the week numbering system to use and the first day of the week. The default return_type is 1. In week numbering system 1, the week of January 1st is Week 1; in week numbering system 2, the week containing the first Thursday of the year is Week 1.
- 1: Numbering system 1 and the week runs from Sunday to Saturday.
- 2: Numbering system 1 and the week runs from Monday to Sunday.
- 11: Numbering system 1 and the week runs from Monday to Sunday.
- 12: Numbering system 1 and the week runs from Tuesday to Monday.
- 13: Numbering system 1 and the week runs from Wednesday to Tuesday.
- 14: Numbering system 1 and the week runs from Thursday to Wednesday.
- 15: Numbering system 1 and the week runs from Friday to Thursday.
- 16: Numbering system 1 and the week runs from Saturday to Friday.
- 17: Numbering system 1 and the week runs from Sunday to Monday.
- 21: Numbering system 2 and the week runs from Monday to Sunday.
Example
Formula | Result |
|---|---|
=WEEKNUM("10/4/2016 5:37 PM") | 41 |
=WEEKNUM("10/4/2016",21) | 40 |