schedule

[Selva]

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)

 

[Mike H]

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

 

[Bob Phillips]

You seem to be ignoring one day, so probably

=WORKDAY(WORKDAY(StartDate,-1),6,holidays)