HomeExcel Functions ► Excel WEEKNUM Function

Syntax For Excel WEEKNUM Function

What is the use of Excel WEEKNUM Function?

Use Excel WEEKNUM Function to get week number of a date which you specified. In simple words, it will tell you the date that you have mentioned is in which week of the year.

Syntax for Excel WEEKNUM Function

WEEKNUM(serial_number,return_type)

serial_number  A serial number which represents the date for which you want to get the week number.

return_type  A number to specify the starting day of the first week of the year. you have two systems to specify starting date the week.

  • System 1:    In this system, the week which has January 1 is the first week of the year, and is numbered week 1.
  • System 2:   In this system, the week containing the first Thursday of the year is the first week of the year and is numbered as week 1. This system is based on the European week numbering system.

You can use following numbers for the return type.

NumberDescription
1 or omittedSystem 1: Starting From Sunday
2System 1: Starting From Monday
11System 2: Starting From Monday
12System 2: Starting From Tuesday
13System 2: Starting From Wednesday
14System 2: Starting From Thursday
15System 2: Starting From Friday
16System 2: Starting From Saturday
17System 2: Starting From Sunday
21System 2: Starting From Monday

Excel stores the dates in serial numbers so that you can only use date which has the valid serial numbers.

More Information on Excel WEEKNUM Function

Excel stores the dates in serial numbers so that you can only use date which has the valid serial numbers.

  • Excel stores the dates in serial numbers so that you can only use date which has the valid serial numbers.
  • If the serial number of date is out of range for the current date base value, a #NUM! is returned.
  • If Return type is out of the range specified in the table above, a #NUM! is returned.

Examples to understand Excel WEEKNUM Function

Examples To Understand Excel Weeknum Function With Today Function

In above example, I have used Today Function with Weeknum to get the week number of the current date. It will update the week number automatically every time when the date changes.

Examples To Understand Excel Weeknum Function

In above example, I have added text “Week-” with the week number for a meaningful result. This can help me to categorize date on week basis.

Download Sample File

Download Sample File To Learn Excel WEEKNUM Function

More Tips Related With Excel WEEKNUM Function

Conclusion

Use Excel WEEKNUM Function to get the week number of a given date. Learn more about WEEKNUM from here.

Related Function

Weekday

Blog | Excel Functions