Actually, no. I meant it the way I said it. After all, NASA says "T minus
whatever". But, of course, either works just fine. :)
************
Anne Troy
www.OfficeArticles.com

"Sandy Mann" wrote in message
...
"Anne Troy" wrote in message
...
=NOW()-A1

That will return a negative number, I assume that you mean

=A1-NOW()

--
Regards


Sandy

Replace@mailinator with @tiscali.co.uk


"Anne Troy" wrote in message
...
=NOW()-A1
Where 10/7/2005 is in A1.
************
Anne Troy
www.OfficeArticles.com

"SeekingHelp" wrote in message
...
How can I set up a formula in Excel to countdown from NOW to a certain
date
and time. i.e. the number of days, hours, and minutes between NOW and
Oct 7.

Thanks!