WORKDAY(start_date,days,holidays) returns the serial number of the date before or after a specified number of workdays : WORKDAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. WORKDAY
Input the formula: =WORKDAY(A2,A3). Press Enter to get the result.
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.