How to Use Excel's WORKDAY Function

Save

Excel's WORKDAY function returns the number of work days before or after a specified date. It will not count weekends or other dates designated as holidays and frequently is used to calculate delivery times or invoice due dates.

  • Install the Analysis ToolPak, if needed. If WORKDAY returns the #NAME? error value, you will need to go to the Tools menu and select Add-Ins. Mark the checkbox next to Analysis ToolPak and click on the OK button.

  • Learn the syntax of WORKDAY. It is WORKDAY (start_date, days[, holidays]) where start_date is the beginning date, and days is the number of work days before or after start_date. Holidays is an optional argument that specifies the holidays to exclude from the calculation.

  • Enter start_date using the DATE function or some other function that returns a date to prevent the problems that can occur when a date is entered as text. WORKDAY will return the #VALUE! error value if start_date is not a valid date.

  • Provide an integer for days. A negative integer will count the work days before start_date and a positive integer will count the work days after start_date. WORKDAY will return the #NUM! error value when an invalid date is produced when a number of days is added to start date.

  • Study an example of WORKDAY by entering the following in an Excel spreadsheet: =WORKDAY(DATE(2008,10,1),151,A2:A4) returns May 5, 2009. The 151st day after October 1, 2008, is May 5, 2009, excluding weekends and holidays.

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!