ADDWORK
ADDWORK(date, duration, [calendar])
The date that a given amount of working time after another date lands on, stepping through the calendar the way CPM does. It counts on the calendar of the task the date belongs to, so five days after a Friday finish is a different date on a 5-day task than on a 7-day one.
Arguments
| Argument | What to give it |
|---|---|
| date | A date, like [Finish date] or DATADATE(). Blank gives blank. |
| duration | Working time, like 5d, 2w or [Total float]. A bare number is working days of the task's calendar. Blank gives blank. |
| calendar | Optional: a calendar's name in quotes, like "7-day", to step through that calendar instead. Left out, it's the calendar of the task the date belongs to; a date that belongs to no task, like DATADATE(), steps through the project's calendar. |
Examples
Formula=ADDWORK([Finish date], 5d)
The date five of the task's working days after it finishes. [Finish date] + 5d is the same thing.
=ADDWORK([Finish date], [Total float])
The task's finish moved on by its total float, on its own calendar: how late it could finish before it delays the project.
Formula=ADDWORK(DATADATE(), 10, "7-day")
Ten working days of the 7-day calendar after the data date, whatever calendar the task is on.
Formula=MAX(ADDWORK(Predecessors[Finish date], 2d))
Two working days after the last predecessor finishes, each predecessor's two days counted on its own calendar.
Reach for something else when
| You want | Use |
|---|---|
| The working time between two dates | WORKDAYS |
| The last day of a month | EOMONTH |
| A date from a year, month and day | DATE |
Common questions
Is ADDWORK different from [Finish date] + 5d?
No. Adding a duration to a date steps through the same calendar ADDWORK uses. ADDWORK is there when you want to name a calendar, or find it reads more plainly.
Why does + 5 add working days, not calendar days?
A bare number next to a date is working days of the task's calendar, the language's one implicit conversion. For calendar days, step through a 7-day calendar: ADDWORK([Finish date], 5, "7-day"). See durations.
Why does a what-if of the data date ask me to name a calendar?
A data date set in a what-if is one value for the whole project, but ADDWORK without a calendar counts on each task's own. The editor says so: SETTING("Data date") is one value for the project, but ADDWORK and WORKDAYS count on each task's own calendar. Name one: ADDWORK(…, 5d, "Standard").
=WORKDAYS([Finish date], IN(WHATIF(SETTING("Data date"), ADDWORK(DATADATE(), 10d, "Standard")), [Finish date]))
How much later the task would finish if the data date were ten working days later with no more progress.