View Single Post
  #4   Report Post  
Steph in PA
 
Posts: n/a
Default


"Steph in PA" wrote in message
...
"Andy B" wrote in message
...
Hi

Yes you can subtract dates. They are just numbers in Excel. Format the
result as Number.

Andy.



Thanks Andy, but I tried subtracting 5/12/05 from 5/23/05, and it came out
with 1/12/00!!! Not "12 days", which is the correct answer!

That should be 5/11/05 from 5/23/05, but it still comes out with the wrong
answer!