The WORKDAY function is the opposite of the NETWORKDAYS function. For example, if you start a project on January 4, and the project requires ten working days to complete, the WORKDAY function can calculate the date you will finish the project.

In versions prior to Excel 2007, the WORKDAY function was available only when the Analysis ToolPak add-in was installed. The function is now part of Excel 2007.

The following formula uses the WORKDAY function to determine the date that is 10 working days from January 4, 2008. A working day consists of a week day (Monday through Friday).

=WORKDAY(“1/4/2008”,10)

The formula returns a date serial number, which must be formatted as a date. The result is January 18, 2008 (four weekend dates fall between January 4 and January 18).

=WORKDAY(DATE(2008,1,4),10)

The second argument for the WORKDAY function can be negative. And, as with the NETWORKDAYS function, the WORKDAY function accepts an optional third argument (a reference to a range that contains a list of holiday
dates).

• Athlete Profiles: Venus Williams Venus Williams and her sister Serena are two of the most easily recognized players in the game and they have...
• Shelter Cove Marina, San Diego, CA Phone: 619.224.2471 Average Water Depth: The average water depth in this area is 11 feet, but this can change. Please...
• Lake Isabella, Lake Isabella, CA Lake Isabella is located in Lake Isabella, CA Phone: (760) 379-2806 Is boating allowed? Yes, boating is encouraged and there...
• Riverbend Golf Club, Madera, CA Riverbend Golf Club is located in Madera, CA Phone: 559-432-3020 Website: http://www.riverbendgolf.com Course History: This is a private course that...
• Use Math To Alleviate Fear Of Stock Market Volatility Over the last ten years, the S&P 500 had returns of 26%, -37%, 5%, 16%, 5%, 11%, 29%, -22%, -12%,...