View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JH JH is offline
external usenet poster
 
Posts: 64
Default 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