Formula, Calculation if active club member

[Kanu_Haselhorst]

Hello,

I’m head of a kayaking club. We need to know if a member is a active member or not. We have a column with a date. This is the last day they are members. If todays date is after the last date they are member or if the column Verstorben (Death date) isn’t empty the output should be false.

My current formula: or({Austritt-Datum} < today(), {Verstorben})

I have an error is the formula. Can someone help out?

[rdb]

Can you try with an ifs formula.

I’d look something like this: ifs({last member date} < today(), “not active”, {Todesdatum} < today(), “not active”, “a” = “a”, “active”}

The part “a” = “a” makes sure that all other members are marked as “active”.

[rdb]

Did I answer your question?

[rdb]

I guess this topic was solved.

I take the liberty of closing it.