You need a nested if he
=IF(TODAY()-E9<=45,E9+45-TODAY()&" days
remain",IF(TODAY()-E945,TODAY()-E9-45&" days over",""))
should work for you.
"adib" wrote:
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