software

Hi,

Pls guide me on this matter. I enter formula:

=9/5/2006-TODAY()amp;quot; days to goquot;

it display, 182 days to go
but when the date over, it turn negatif, like '-5 days to go'
How to stop the countdown after the date?

Hi

You could use the MAX function:
=MAX(9/5/2006-TODAY(),0)amp;quot; days to goquot;

Andy.

quot;Paramquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Pls guide me on this matter. I enter formula:
gt;
gt; =9/5/2006-TODAY()amp;quot; days to goquot;
gt;
gt; it display, 182 days to go
gt; but when the date over, it turn negatif, like '-5 days to go'
gt; How to stop the countdown after the date?

=9/5/2006-TODAY()amp;quot; days to goquot;

use an if function

if (9/5/2006-today()gt;0= 9/5/2006amp;quot;days to goquot;,quot;Arrivedquot;)

Assuming you have entered the date correctly!

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=519368Something like this maybe:

=IF( TODAY() =DATEVALUE(quot;9/25/2006quot;), quot;Arrivedquot;, IF(TODAY() gt;
DATEVALUE(quot;9/25/2006quot;), quot;In the pastquot;,DATEVALUE(quot;9/25/2006quot;) - TODAY() amp; quot;
days to goquot;))

--
Kevin Vaughnquot;Paramquot; wrote:

gt; Hi,
gt;
gt; Pls guide me on this matter. I enter formula:
gt;
gt; =9/5/2006-TODAY()amp;quot; days to goquot;
gt;
gt; it display, 182 days to go
gt; but when the date over, it turn negatif, like '-5 days to go'
gt; How to stop the countdown after the date?