Calculating Late Fees?

Hi everyone!

I am setting up a spreadsheet to keep track of my club dues.

We have monthly meetings, this is when we pay our monthly membership due of $20. If a member is late paying, they are charged $10, if they miss a meeting, they are charged $10.



This is what would be ideal.


1. One column that tracks how many days late and adds the Late Fees. This column then adds this total to their total owed.
2. One column that tracks how many missed meetings and adds the Missed Meeting Fees. Technically the same as above.
3. Some way to overwrite these fields for special circumstances such as approved late payment.
4. If a person misses a meeting, they do not get charged for late payment.


I have attached my starting spreadsheet with temporary info. Any help would be so grateful.

You have a good point and that is what I am working on right now to figure out as well, some type of layout. Although, we only have one meeting per month and yes, we might have the meeting on the 1st and then have it on the 30th of the next month so that then would be longer than a months time making it seem late but it isn't. Suggestions or welcome.

Thank you for the help.

Okay I kind of follow you. Basically adding another sheet where I would take attendence. Anyone not there or who didn't pay will trigger a fee tacked on. How would I connect them?