View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NM NM is offline
external usenet poster
 
Posts: 51
Default Sum working days

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.