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)

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)

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)