Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Networkdays
Hello
I'm trying to do the following using the Networkdays function but having difficulty. Based on a given week day (Mon - Fri) I'm trying to find the date 3 business days into the future; excluding weekends and holidays. Eg. For the month of March 2005 Given Result in Mon Mar. 21 Thu Mar. 24 (3 business days) Tue Mar. 22 Mon. Mar. 28 (3 business day excluding Good Friday + Sat. & Sun.) I would have the holidays for the year contained in cells A16:A23 Your help on this would be greatly appreciated Susan |
#2
|
|||
|
|||
Hi
With base date in A1: =WORKDAY(A1,3,$A$16:$A$23) Arvi Laanemets "Susan Hayes" wrote in message ... Hello I'm trying to do the following using the Networkdays function but having difficulty. Based on a given week day (Mon - Fri) I'm trying to find the date 3 business days into the future; excluding weekends and holidays. Eg. For the month of March 2005 Given Result in Mon Mar. 21 Thu Mar. 24 (3 business days) Tue Mar. 22 Mon. Mar. 28 (3 business day excluding Good Friday + Sat. & Sun.) I would have the holidays for the year contained in cells A16:A23 Your help on this would be greatly appreciated Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
networkdays or dias.lab | Links and Linking in Excel | |||
Networkdays shows as #NAME even though I have the toolpack instal. | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |