Help

Expiration Date on Membership Database

Topic Labels: Formulas
1038 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alyssa_Thomas
4 - Data Explorer
4 - Data Explorer

Hello,

I’m working on a membership database for a non-profit. I would like to have a column that denotes if the account is Active (meaning paid membership within the last year) or Expired (not paid within the last year). I have an expiration date column already in the table, but am having trouble creating a formula that works. I know it’s something like "If expiration date is before today, “expired” is after, “active”. However I cannot get any of my attempts at formulas to work.Thoughts?

1 Reply 1

Try:

IF(
   {Expiration Date} < TODAY(),
   "Expired",
   "Active"
)