Excel Date Functions : WEEKNUM

Introduction to WEEKNUM Function

WEEKNUM function returns the week number of a date. In simple words, WEEKNUM returns the week number of dates that you specify ranging from 1 to 54.

Download Sample File

Download Sample Files to work, practice and master the Date Functions in Excel.

Syntax of WEEKNUM Function

WEEKNUM(serial_number,return_type)

Arguments of WEEKNUM Function

• serial_number: A 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 the starting date of the week.

Example of WEEKNUM Function in MS Excel

In the below example, we have used TODAY with WEEKNUM to get the week number of the current date. It will update the week number automatically every time the date changes.

In the below example, we have added the text “Week-” with the week number for a meaningful result.

Other Excel Date Functions Tutorials

You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.

• DATE Function
• DATEVALUE Function
• DAY Function
• DAYS Function
• EDATE Function
• EOMONTH Function
• MONTH Function
• NETWORKDAYS Function
• NETWORKDAYS.INTL Function
• TODAY Function
• WEEKDAY Function
• WEEKNUM Function
• YEAR Function