Looking to set up an If formula, normally have no problems with them, but this one has me really confused.
I have a large list of dates, but what I want is that if say F4 was older than 90 days from today it would show "lapsed" whereas if F4 was todays date or was in the future, it would say "member" but if it is between the two, so older than today but less than 90 days old, it would say "grace"
Is it possible to do this??
Thanks in advance