View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
DOUG ECKERT[_2_] DOUG ECKERT[_2_] is offline
external usenet poster
 
Posts: 66
Default NETWORKDAYS Troubleshoot

David: The cell contained text. I added a date (or day figure) to the text,
thus converting it to a date and it worked.

Thank you.

DOUG

"David Biddulph" wrote:

What formula are you using?
What date values are in the cells to which the formula refers?
What value did you get from the formula?
What value did you expect?
Have you ensured that Tools/ Options/ Calculation is set to Automatic, not
Manual?
--
David Biddulph

"DOUG ECKERT" wrote in message
...
NETWORKDAYS should yield a higher count of days as time goes by, but it
does
not for some reason.

'Any thoughts?

DOUG