View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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