Formula Help - Microsoft Community

hello all,

i'm trying cell change it's name either "active", "default" , "extend",

my first formula was:

=if([@[redemption date]]>today(),"active","default")

which worked fine, untill i tried include "extend".

i cell "extend" when [@[redemption date]] within 3 months of today().

this far got:

=and (if([@[redemption date]]>today(),"active","default"),if([@[redemption date]]<eomonth([@[redemption date]],-3)),"extend","active"))

if able advise me on grateful. 

thank in advance help.

best wishes,

julian

try this

=if([@[redemption date]]<=today(),"default",if([@[redemption date]]<=today()+90,"extend","active"))

Office / Excel / Windows other / Office 2010