Hi,

Pls guide me on this matter. I enter formula:

=9/5/2006-TODAY()&" days to go"

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)&" days to go"

Andy.

"Param" wrote in message
...
Hi,

Pls guide me on this matter. I enter formula:

=9/5/2006-TODAY()&" days to go"

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?

=9/5/2006-TODAY()&" days to go"

use an if function

if (9/5/2006-today()0= 9/5/2006&"days to go","Arrived")

Assuming you have entered the date correctly!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519368

Something like this maybe:

=IF( TODAY() =DATEVALUE("9/25/2006"), "Arrived", IF(TODAY()
DATEVALUE("9/25/2006"), "In the past",DATEVALUE("9/25/2006") - TODAY() & "
days to go"))

--
Kevin Vaughn


"Param" wrote:

Hi,

Pls guide me on this matter. I enter formula:

=9/5/2006-TODAY()&" days to go"

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?