| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
schedule
How do i get the the finish date using the excel sheet for the following
scenerio. Start date : 1-Dec-08 Duration : 6 days Holiday : 8-Dec-08 Finish date : 9-Dec-08 (exculdes the weekends & Holiday) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
schedule
Hi,
=WORKDAY(A1,A2,Holidays) Where A1 is the start date A2 is the duration Holidays is a named range that contains any holidaye days If you get a NAME# error then Tools|Addins and select the analysis toolpak Mike "Selva" wrote: How do i get the the finish date using the excel sheet for the following scenerio. Start date : 1-Dec-08 Duration : 6 days Holiday : 8-Dec-08 Finish date : 9-Dec-08 (exculdes the weekends & Holiday) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
schedule
You seem to be ignoring one day, so probably
=WORKDAY(WORKDAY(StartDate,-1),6,holidays) -- __________________________________ HTH Bob "Selva" wrote in message ... How do i get the the finish date using the excel sheet for the following scenerio. Start date : 1-Dec-08 Duration : 6 days Holiday : 8-Dec-08 Finish date : 9-Dec-08 (exculdes the weekends & Holiday) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tennis Schedule - Schedule players randomly | Excel Discussion (Misc queries) | |||
| schedule | Excel Discussion (Misc queries) | |||
| Schedule | Excel Worksheet Functions | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| Help with schedule | Excel Worksheet Functions | |||
Hybrid Mode
