Date Time Functions MSOfficeExcel 2007 Tutorial

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