View Single Post
  #5   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

As Andy said:

Format the
result as Number.


--

Vasant

"Steph in PA" wrote in message
...

"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!