Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2021 01:09 PM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2021 04:42 PM
Try:
IF(
{Expiration Date} < TODAY(),
"Expired",
"Active"
)