# Weekly Payment End Date (based on 4 weekly payments per month)

1. ## Weekly Payment End Date (based on 4 weekly payments per month)

I need a formula to calculate the last weekly payment date, based on only taking 4 weekly Friday payments in a month. If there is a 5th Friday in a month, this is a bye-week (with no payment taken). I cannot seem to figure out a formula to calculate when the actual last payment DATE would be.

In my specific incidence, I need to take 128 weekly Friday payments of \$750 for a total of \$96,000 (with every 5th Friday in a month excluded over the period of these 128 weekly payments), starting 11/04/22 to get to the last payment "date".

Any help with creating a formula to do this would be appreciated!

Thank you!

2. ## Re: Weekly Payment End Date (based on 4 weekly payments per month)

Delete delete

5. ## Re: Weekly Payment End Date (based on 4 weekly payments per month)

I have no idea how to do it with simple formulas. I have to put up the whole payment schedule. Please see workbook attached.

There are currently 1 users browsing this thread. (0 members and 1 guests)