How to use WEEKNUM Function in Excel

Week Number (WEEKNUM) is a date function in excel which gives us the week number for the given date in a date, it has two arguments in it one which takes a date as an argument which can be a date or a serial number and the other argument is optional which represents the day on which the week begins, the second argument is optional however the first argument is mandatory and the method to use this weeknum function is as follows =Weeknum(Serial Number, Return Type), if the return type is not provided it is considered one by default which Sunday.

Syntax: =WEEKNUM(serial_number,[return_type])

The WEEKNUM function syntax has the following arguments:

  • Serial_number     Required. A date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
  • Return_type     Optional. A number that determines on which day the week begins. The default is 1.

Example: Let’s look at some Excel WEEKNUM function examples and explore how to use the WEEKNUM function as a worksheet function in Microsoft Excel:

Syntax:  =WEEKNUM(A2)

Result:

Based on the Excel spreadsheet above, the following WEEKNUM examples would return:

Syntax: =WEEKNUM(A3)
Result: 8

Syntax: =WEEKNUM(A4)
Result: 10

Syntax: =WEEKNUM(A5)
Result: 26

Syntax: =WEEKNUM(A6)
Result: 5

Syntax: =WEEKNUM(A7,2)
Result: 35

Syntax: =WEEKNUM(A8,2)
Result: 22

Syntax: =WEEKNUM(A9,2)
Result: 40

Syntax: =WEEKNUM(A10,2)
Result: 13

Syntax: =WEEKNUM(A11,2)
Result: 51

Syntax: =WEEKNUM(A12,2)
Result: 3

Note:

  • By default start of the week in excel is SUNDAY.
  • If you want to start with a different week then you need to supply the return type correctly.
  • If the date is not in the correct format then we will get #VALUE! Error.

Add a Comment

Your email address will not be published. Required fields are marked *