Calculate a future date, excluding weekends.

[Guest]

If a project takes 25 days and starts today, what is the formula to predict the date the work is complete where there is a typical 5 day, Mon-Fri workweek?

thanks

 

[Aladin Akyurek]

On 2002-03-07 10:49, Anonymous wrote:
If a project takes 25 days and starts today, what is the formula to predict the date the work is complete where there is a typical 5 day, Mon-Fri workweek?

thanks

=WORKDAY(A1,25)

or

=WORKDAY(A1,25,HOLIDAYS)

where A1 houses a start date (e.g., today) and HOLIDAYS (in the second formula) is a range where you put known holiday dates, so you can exclude them to in determing the fure date.

The function WORKDAY requires that the Analysis Toolpak is activated (via Tools|Add-Ins).