We are currently updating our attendance tracking on our base.
What we currently have is the following base:
What it does is that on the Member Attendance sheet, we get to input attendances for each of our members.
And if that member’s entry through the space is passport or not. We count them.
What we want to do further is that if the Member Attendance Date IS_BEFORE the Renewal Date. We will no longer include them on the total summation for attendances.
As of now, we’re currently having trouble formulating a formula for what we want to happen. Any assistance on the matter is much appreciated.
I’m planning on adding the update to the Membership Entries column.
Here’s the formula for the Membership Entries Column:
What I want to do is to exclude the Membership Entry Count values whose dates are before the Renewal date.