I am relatively new to Filemaker and am building a class/course management solution in which students take classes weekly but are charged monthly. When a student joins their first month's fee is pro-rated based on the number of classes remaining in that calendar month.
For example, if a student's first class is on Monday 12th March 2018, they will need to be charged for 3 Monday classes that month as they will have missed the first Monday class.
Is there a way to calculate how many Mondays are left in a calendar month based on providing a specific start date?
Thanking you in advance for any help or suggestions.