Formula help: Duration Without Weekend Days
 

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

Formula help: Duration Without Weekend Days
 

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



"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

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

Formula help: Duration Without Weekend Days
 

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

"JH" wrote:

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



"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

Formula help: Duration Without Weekend Days
 

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?
--
David Biddulph

"JP" wrote in message
...
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

"JH" wrote:

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



"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