Use the WORKDAY function to determine the date ten working days from January 8, 2007. : WORKDAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. WORKDAY
A working day is a weekday (Monday through Friday).

Input the formula: =WORKDAY("1/8/2007",10)
15.17.WORKDAY
15.17.1.WORKDAY(start_date,days,holidays) returns the serial number of the date before or after a specified number of workdays
15.17.2.Use the WORKDAY function to determine the date ten working days from January 8, 2007.