Today function is driving me nuts
=IF(A4+30=TODAY(),"Renew","")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Danny J" wrote in message
...
Hi folks,
I am trying to do something really simple. Cell A4 has an expiry date,
Cell
B4 has a formula which should give a renew message if the expiry date is
within 30 days of todays date....except it doesn't. Remove Today() and it
works. aaaaarrrrgh!
The formula is =if(today()-30<=a4,"renew","")
Any help much appreciated
Danny
|