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?