Get the day of the first day of the year 2007 : WEEKDAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =WEEKDAY(DATE(2007,1,1))
Input the formula: =WEEKDAY(DATE(2007,1,1))
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