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

WEEKDAY(serial_number, return_type)

 
 Returns the day of the week for a given date.

 serial_numberThe date as a serial number.
 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
 
  		• The "serial_number" can be a date value, a serial number or a reference to a cell containing a date.
     
  		• The "serial_number" cannot be a text string.
     
  		• If "return_type" is left blank, the 1 is used.
     
  		• You should try and enter your dates using the DATE() function.
     
  		• You can also use the TEXT() function to convert a value to a specified number format.

     EXAMPLES
     
     AB
    1=WEEKDAY(B1,1) = 601 July 1977
    2=WEEKDAY(DATE(1977,7,1)) = 6=NOW() = 31/07/2007
    3=WEEKDAY(B1,2) = 5=NOW() = 39295
    4=WEEKDAY(DATE(1977,7,1),2) = 5 
    5=WEEKDAY(1/7/1977,2) = 6 
    6=WEEKDAY(NOW(),2) = 2 
    7=WEEKDAY(B2,2) = 2 
    8=WEEKDAY(38093,2) = 5 
    9=TEXT(WEEKDAY(DATE(1977,7,1)),"dddd") = Friday 
    10=TEXT(WEEKDAY(DATE(2004,7,1)),"dddd") = Thursday 
    		 
     Functions - W | Index - W | Dates & Times | Office Online 

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