Question
What is the WORKDAY function in Excel?
Answer
The WORKDAY function can be used to calculate the end date or start date of a project for a given number of business days. The number of business days cannot include weekend days. Specific holidays can also be omitted.
The syntax for the WORKDAY function is: = WORKDAY ( Start_date, Days, Holidays )
- Start_date - the start date of the project or time period in question.
- Days - the number of days work on the project occurred after the Start_date.
- Holidays - can be used to exclude one or more dates from the total number of working days (optional).
For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3
If you need further assistance, please click the CTL Support Request button on this page