AnsweredAssumed Answered

How to calculate the remaining number of a specific day in a month

Question asked by koachie on Mar 19, 2018
Latest reply on Mar 22, 2018 by fmpdude

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. 

Outcomes