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!
Bookmarks