Can This Be Done in Excel?
It can be done in Excel.
Assign a column that will contain dues expiration date. This assumes
that a given dues amount will cover a block of time rather than a
number of sessions. If the sign-in date is less than the expiration
date, all is well. If the sign-in date is after the expiration date,
an alert can be issued (using Conditional Formatting).
If dues covers a number of sessions, then different logic will be
required.
|