=IF(TODAY()-E9<45,E9+45-TODAY()&"day's
remain",IF(TODAY()-E945,TODAY()-E9-45&"day's over",""))
--
__________________________________
HTH
Bob
"adib" wrote in message
...
Hi, in cell E9 have date 1/15/2009 i have the following formula but its
return false.please solve this what mistake i did
=IF(TODAY()-E9<45,E9+45-TODAY()&"day's
remain","")=IF(TODAY()-E945,TODAY()-E9-45&"day's over","")
Thanks
--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73859