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.



"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

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

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

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