View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Sum working days

Use the WORKDAY function. Look it up in Excel help.
--
David Biddulph

"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.