WEEKNUM

How to display what week number of a year a specific date is on in Excel 2010 WEEKNUM

1.      Go to the Formula tab> Select the Date & Time drop down list

2.      Click on WEEKNUM

 

3.      The function argument window will pop up

 

4.      In the Serial_number input box enter the required date with quotes (M/D/YYYY)

5.      In the return type enter 1 for Sunday as the first day of the week or 2 for Monday as the first day of the week

6.      Click on OK

7.      The result given for the 2^ndof August 2012 with Sunday being the first day of the week is

 

8.  So we are in week 31 of the year