NASA may be able to work with negative time but Excel can't unless the 1904
date syetm is selected which will change the date in A1 from 10/7/05 to
10/8/09 - but then you knew that <g

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"Anne Troy" wrote in message
...
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!