Formula help: Duration Without Weekend Days

[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

 

[JH]

You simply need to use the worksheet function, "networkdays", you can get
more details from the help file on this function.

 

[Dave Peterson]

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]

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

 

[David Biddulph]

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?