WEEKDAY(serial_number,return_type) converts a serial number to a day of the week : WEEKDAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. WEEKDAY
WEEKDAY(serial_number,1 or omitted) returns numbers 1 (Sunday) through 7 (Saturday).

WEEKDAY(serial_number,2) returns the numbers 1 (Monday) through 7 (Sunday).

WEEKDAY(serial_number,3) returns the numbers 0 (Monday) through 6 (Sunday).

Input the formula: =WEEKDAY(2/14/2008). Press Enter to get the result.
Input the formula: =WEEKDAY(2/14/2008)








15.15.WEEKDAY
15.15.1.WEEKDAY(serial_number,return_type) converts a serial number to a day of the weekWEEKDAY(serial_number,return_type) converts a serial number to a day of the week
15.15.2.=WEEKDAY(2/14/2008,2)
15.15.3.Get the day of the first day of the year 2007Get the day of the first day of the year 2007