View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formula help: Duration Without Weekend Days

It sounds like you want to use =networkdays()

If you're using xl2003 or below, you'll have to have the analysis toolpak
loaded. Excel's help for =networkdays() will show you how.



JP wrote:

Hi, I'd like to compute the duration of a series of tasks by subtracting the
end date from the start date--but also removing the weekend days to give an
accurate 'days' count. Thanks in advance for your replies, JP


--

Dave Peterson