View Single Post
  #5   Report Post  
Old May 23rd 05, 08:03 PM
Vasant Nanavati
 
Posts: n/a
Default

As Andy said:

Format the
result as Number.


--

Vasant

"Steph in PA" wrote in message
news

"Steph in PA" wrote in message
news
"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!