Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Please disregard, answer attained
Thank you |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
How do I install the networkdays function! | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |