View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karl Karl is offline
external usenet poster
 
Posts: 114
Default Adding network days


Hi,

I wonder if anyone can help. I have a table with three columns.

€¢ Column A shows the start date of a task
€¢ Column C shows the tasks duration
€¢ Column B adds the number of days in column C to the start date in column A
to arrive at the tasks end date.

I want column B, instead of adding €˜x number of days to the start date to
add €˜x number of working days. Can anyone tell me how to do this?

Ive been playing around with the NETWORKDAYS function, but cant find a way
to do just what I want.

Thanks

Karl