Formula help: Duration Without Weekend Days

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

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
 
You simply need to use the worksheet function, "networkdays", you can get
more details from the help file on this function.
 
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.
 
Thanks, JH - but it looks like my version of Excel doesn't include this handy
function, unless I missed something.

I use 2003 SP3 - is there an alternate way of doing this?

Thanks again,
JP
 
Did you look up "networkdays" in Excel help, as JH suggested? What did it
tell you? Why do you think that you don't have the function?
 
Back
Top