WEEKNUM Function in Excel – Get the Week Number of the year from date

The WEEKNUM function in Excel takes a date and returns a week number (1-54) that corresponds to the week of year. WEEKNUM Function counts week starting with January 1 as first week.

Syntax for WEEKNUM Function in Excel

WEEKNUM (serial_number, [return_type])

serial_number – The date for which you want to get the week number.

return_type – [optional], The day at which the week begins. Default is 1

weeknum Function in excel formula 1

 

Example of WEEKNUM Function in Excel

WEEKNUM Function with default return_type or return_type =1

When Return type =1, Week number is calculated by keeping Sunday as first day of the week  and Saturday as last day of week.

Formula:

weeknum Function in excel 1

Result

weeknum Function in excel 2

 

WEEKNUM Function with return_type =2

When Return type =2, Week number is calculated by keeping Monday as first day of the week  and Sunday as last day of week

Formula:

weeknum Function in excel 3

Result

weeknum Function in excel 4

previous-small WEEKNUM Function in Excel                                                                                                                 next_small WEEKNUM Function in Excel