Excel Function : WEEKNUM
Category
Date and time
Description
Converts a serial number to a number representing where the week falls numerically with a year
Microsoft Excel Reference Page
https://support.office.com/en-us/article/WEEKNUM-function-e5c43a03-b4ab-426c-b411-b18c13c75340
Syntax and Description of the WEEKNUM Excel Function
The Syntax for the WEEKNUM function is: WEEKNUM(date,[type]) date - The date to use in the function. type - The type of week numbering system to use. This is an optional argument and if omitted, the default value is 1. The type argument has the following options: 1 - Uses the standard system where weeks start on Sunday and the first week of the year (Week 1) is the week that contains at least four days in the year. 2 - Uses a system where weeks start on Monday and the first week of the year (Week 1) is the week that contains at least four days in the year.
About WEEKNUM Excel Function
WEEKNUM(serial_number, [return_type]) The WEEKNUM function returns the week number of a given date. The week starts on Sunday.
