Return task end date
This tutorial shows how to get the task end date using an Excel formula, with the WORKDAY function
Hard coded formula
Cell reference formula
|
=WORKDAY("3/2/2019",10,$H$5:$H$12)
=WORKDAY(C5,D5,$H$5:$H$12)
|
GENERIC FORMULA
=WORKDAY(date,days,holidays)
ARGUMENTS GENERIC FORMULA
=WORKDAY(date,days,holidays)
ARGUMENTS EXPLANATION This formula uses the WORKDAY function to return the end date of a task by selecting the start date of the task and adding the number of days the task takes to complete. This formula also takes into consideration holidays, however, this is an optional parameter, therefore can be completely excluded from the calculation.
Click on either the Hard Coded or Cell Reference button to view the formula that has the start date of the task and the number of days the task takes to complete directly entered into the formula or referenced to specific cells. |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Add workdays to date | How to add workdays to a date | |
| Return workdays between dates | How to return the number of working days (business days) between two dates |