Today function is driving me nuts

[Danny J]

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

 

[Bob Phillips]

=IF(A4+30>=TODAY(),"Renew","")

--

HTH

RP
(remove nothere from the email address if mailing direct)