Return task start date
This tutorial shows how to get the task start 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 start date of a task by selecting the end date of the task and subtracting 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 end 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 |
|---|---|---|
| Return task end date | How to get the task end date | |
| 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 |