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
|