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)