Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > WEEKNUM
 

WEEKNUM(serial_num [,return_type])

 
 Returns the week number in the year for a given date.

 serial_numThe date within the week.
 return_typeThe number that specifies on what day the week begins:
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• If "return_type" is left blank, then 1 is used.

     EXAMPLES
     
     A
    1=WEEKNUM("1/10/1999",1) = 40
    2=WEEKNUM("1/10/1999",2) = 40
    3=WEEKNUM("1/7/1977") = 27
    4=WEEKNUM("1/7/1977",1) = 27
    5=WEEKNUM(DATE(7,2,2005)) = 31
    		 
     Functions - W | Index - W | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top