View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default using NETWORKDAYS

On Tue, 1 May 2007 09:19:02 -0700, mandy
wrote:

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!


Look at the WORKDAY function.
--ron