Set up a list of holiday dates to be excluded. Assume this list is in the
range J1:J10.

Then, use this formula in column C:

=WORKDAY(A1,B1,J1:J10)

The WORKDAY function requires the Analysis ToolPak add-in be installed for
versions of Excel prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"NM" wrote in message
...
Hi,

Column A has date, Column B has number of days required to finish the
task,
in Column C I want to use a formula which adds Column B( number of days)
to
column A but excludes holidays and weekends and adds only working days.

eg. Column A has 12/8/08 Column B has 7 days coulmn C should be 12/17/08 (
only working days to be added)

Thanks for your help.