You don't need to list the weekend dates, the WORKDAY function knows to
exclude those but you have to list any holiday dates that you want to
exclude from the calculation. You simply enter those dates in a range of
cells:

J1: 1/1/2009
J2: 1/2/2009
J3: 2/21/2009
J4: 5/31/2009
J5: 7/4/2009
etc
etc
etc


--
Biff
Microsoft Excel MVP


"NM" wrote in message
...
What is the easiest way to set up a list of weekends and holidays?

"T. Valko" wrote:

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.