We currently pay weekly on every Friday. Some of our deductions are based on a monthly amount. Health Insurance, Dental, Vision and child support for some of our employees. I was looking towards formulas, but I can't figure out a good way to solve this. If there was a MTD function like QTD/YTD, I could easily solve it.

For instance, each employee that has health insurance pays $331.36 monthly and $82.84 each week up to the monthly limit. But with the fifth pay week it will throw this off. Is there a way to apply a monthly limit for each deduction?