Networkdays function
 

Hello

I'm trying to do the following using the Neworkdays function without success

Given any date (Mon. to Fri.) wish to find the date 3 business days into the future, excluding weekends and holidays.

Eg.

For the Month of March 2005

Given Results in
Mon. Mar. 21 Thu. Mar. 24 (3 business days)
Tue. Mar. 22 Mon. Mar. 28 (3 business day excluding Good Friday; Sat. + Sun.)

Thank you in advance

Susan

Please disregard, answer attained

Thank you

Susan

you actually need WORKDAY

=WORKDAY(A1,3,E1:E8)

Where A1 contains the base date and E1 to E8 contains a list of Bank
Holidays

I think you'll find the second example gives Tuesday, 29 March 2005 as
you've also got Easter Monday in there.

Regards

Trevor


"Susan Hayes" wrote in message
...
Hello

I'm trying to do the following using the Neworkdays function without
success

Given any date (Mon. to Fri.) wish to find the date 3 business days into
the future, excluding weekends and holidays.

Eg.

For the Month of March 2005

Given Results in
Mon. Mar. 21 Thu. Mar. 24 (3 business days)
Tue. Mar. 22 Mon. Mar. 28 (3 business day excluding Good Friday; Sat. +
Sun.)

Thank you in advance

Susan