WEEKNUM() function

Functions May 07, 2019

About WEEKNUM() Function

The WEEKNUM() function is a date function that returns the week number for a specific date in the year. It contains two arguments one is date and second is return_type. it starts counting the week number basis 2nd argument that is return_type.

Where to apply :

You can use WEEKNUM() function in weekly reports to mention the week number in that. The identification of week number is also important for those who track the activities, sales, hiring, delivery of product etc on weekly basis.

Syntax :

=WEEKNUM(date, return_type)

Parameters :

date - A date that should be a positive number.

return_type - Alaways a number in 1, 2, 11, 12, 13, 14, 15, 16, 17, 21.


return_type    Uses


1 is applied in return_type to start counting the week number   from Sunday as 1st day of the week.

2 is applied in return_type to start counting the week number   from Monday as 1st day of the week.

11    is applied in return_type to start counting the week number   from Monday as 1st day of the week.

12   is applied in return_type to start counting the week number   from Tuesday as 1st day of the week.

13   is applied in return_type to start counting the week number   from Wednesday as 1st day of the week.

14   is applied in return_type to start counting the week number   from Thursday as 1st day of the week.

15   is applied in return_type to start counting the week number   from Friday as 1st day of the week.

16   is applied in return_type to start counting the week number   from Saturday as 1st day of the week.

17   is applied in return_type to start counting the week number  from Sunday as 1st day of the week.

21  is applied in return_type to start counting the week number  from Monday as 1st day of the week. (Used number system 2.)

Remember -

1. Microsoft Excel stores dates in numbers so that the calculation can be done easily. It starts date from January 1, 1900 that it stores as 1 and then follows the ascending order to of numbers for date in sequence.

2. If the date argument is not a valid argument, it returns #NUM! error.

3. If the argument is not a valid number, it returns #VALUE! error.

Example :

1. To extract week number from a date -

Let's suppose the date is "01/05/2019" with return type 1.


=WEEKNUM("01/05/2019",1)   // Returns(1)

it returns 1 as it shows that it 1st week of the year.

2. To extract week number from a number -

Let's suppose the number is 43585 that means April 30, 2019 in date form.


=WEEKNUM(43585,1)   // Returns 18

Here it returns 18 as the 18th week of the year for 43585.

Excel based example :

Image 1 - WEEKNUM() function

Explanation of WEEKNUM() function is given in above image.

Hope, it would have added to your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

ExcelHour
9599408486 / 8929231250
Website: https://www.excelhour.in/

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.