Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions
 

Get the day of the first day of the year 2007

Input the formula: =WEEKDAY(DATE(2007,1,1))