Try this

=WORKDAY(A1,B1,Holidays)

Holidays is a named rtange that contains any holidaya dates.

If you get a NAME# error then

Tools|addins and load the analysis toolpak.

Mike

"NM" wrote:

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.