Networkdays function

  • Thread starter Thread starter Susan Hayes
  • Start date Start date
S

Susan Hayes

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
Number of hrs worked in a week, based on dates in a different column 1
The Tueday prior to a holiday... 8
Networkdays including Saturday? 5
Future date with six day week including holidays 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Which function will work best? And how do I set it up? 0
4 if's, with 4 different results 4

Back
Top