include weekend in the "WORKDAY.INTL"

[tobysdhc]

Hello,

In excel I am trying to return a date given a "start date", "excluding holidays", and "a number of days for completion".

For example, given the start date of 9/1/2015, 60 days for completion, excluding holidays, would be XX/XX/XXXX. The "WORKDAY.INTL" function would be great, but I do not know how and cannot find a way to include all days of the week (i.e. no weekends).

Does anyone know how to do this or is there a better function/formula to use?

Thanks,

TobySDHC

 

[Jonmo1]

Try

=WORKDAY.INTL(A1,60,"0000000",E1:E20)

A1 is start date, E1:E20 is list of holidays.

 

[tobysdhc]

Worked great! Had tried 0000000, but hadn't put it in quotes.

Thanks a bunch

 

[Jonmo1]

You're welcome.