Spreadsheet: 801431d1666193614-weekly-payment-end-date-based-on-4-weekly-payments-per-month-weekly-payment-end-date-based-on-4-weekly-payments-per-month-
Sheet: Sheet2

 | Weekly Payment End Date (based on 4 weekly payments per month)
 | https://www.excelforum.com/excel-formulas-and-functions/1391408-weekly-payment-end-date-based-on-4-weekly-payments-per-month.html#post5742703
 | Week | Date | Day | # Fridays in month | Cum. Week without 5th Fridays |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Friday | 2nd Friday | 3rd Friday | 4th Friday | 5th Friday
 | - |  |  |  |  |  | Payment amount | 750
 | 1 |  |  |  |  |  | No. of weekly payments | 128
 |  |  |  |  |  |  | Total payments
 | 3 | 2022-04-15 00:00:00 | Fri |  |  |  | Start date | 2022-04-11 00:00:00
 | 4 | 2022-04-22 00:00:00 | Fri |  |  |  | First payment date
 | 5 | 2022-04-29 00:00:00 | Fri |  |  |  | Last payment date
 | 6 | 2022-05-06 00:00:00 | Fri
 | 7 | 2022-05-13 00:00:00 | Fri
 | 8 | 2022-05-20 00:00:00 | Fri
 | 9 | 2022-05-27 00:00:00 | Fri
 | 10 | 2022-06-03 00:00:00 | Fri
 | 11 | 2022-06-10 00:00:00 | Fri
 | 12 | 2022-06-17 00:00:00 | Fri
 | 13 | 2022-06-24 00:00:00 | Fri
 | 14 | 2022-07-01 00:00:00 | Fri
 | 15 | 2022-07-08 00:00:00 | Fri
 | 16 | 2022-07-15 00:00:00 | Fri
 | 17 | 2022-07-22 00:00:00 | Fri
 | 18 | 2022-07-29 00:00:00 | Fri
 | 19 | 2022-08-05 00:00:00 | Fri
 | 20 | 2022-08-12 00:00:00 | Fri
 | 21 | 2022-08-19 00:00:00 | Fri
 | 22 | 2022-08-26 00:00:00 | Fri
 | 23 | 2022-09-02 00:00:00 | Fri
 | 24 | 2022-09-09 00:00:00 | Fri
 | 25 | 2022-09-16 00:00:00 | Fri
 | 26 | 2022-09-23 00:00:00 | Fri
 | 27 | 2022-09-30 00:00:00 | Fri
 | 28 | 2022-10-07 00:00:00 | Fri
 | 29 | 2022-10-14 00:00:00 | Fri
 | 30 | 2022-10-21 00:00:00 | Fri
 | 31 | 2022-10-28 00:00:00 | Fri
 | 32 | 2022-11-04 00:00:00 | Fri
 | 33 | 2022-11-11 00:00:00 | Fri
 | 34 | 2022-11-18 00:00:00 | Fri
 | 35 | 2022-11-25 00:00:00 | Fri
 | 36 | 2022-12-02 00:00:00 | Fri
 | 37 | 2022-12-09 00:00:00 | Fri
 | 38 | 2022-12-16 00:00:00 | Fri
 | 39 | 2022-12-23 00:00:00 | Fri
 | 40 | 2022-12-30 00:00:00 | Fri
 | 41 | 2023-01-06 00:00:00 | Fri
 | 42 | 2023-01-13 00:00:00 | Fri
 | 43 | 2023-01-20 00:00:00 | Fri
 | 44 | 2023-01-27 00:00:00 | Fri
 | 45 | 2023-02-03 00:00:00 | Fri
 | 46 | 2023-02-10 00:00:00 | Fri
 | 47 | 2023-02-17 00:00:00 | Fri
 | 48 | 2023-02-24 00:00:00 | Fri
 | 49 | 2023-03-03 00:00:00 | Fri
 | 50 | 2023-03-10 00:00:00 | Fri
 | 51 | 2023-03-17 00:00:00 | Fri
 | 52 | 2023-03-24 00:00:00 | Fri
 | 53 | 2023-03-31 00:00:00 | Fri
 | 54 | 2023-04-07 00:00:00 | Fri
 | 55 | 2023-04-14 00:00:00 | Fri
 | 56 | 2023-04-21 00:00:00 | Fri
 | 57 | 2023-04-28 00:00:00 | Fri
 | 58 | 2023-05-05 00:00:00 | Fri
 | 59 | 2023-05-12 00:00:00 | Fri
 | 60 | 2023-05-19 00:00:00 | Fri
 | 61 | 2023-05-26 00:00:00 | Fri
 | 62 | 2023-06-02 00:00:00 | Fri
 | 63 | 2023-06-09 00:00:00 | Fri
 | 64 | 2023-06-16 00:00:00 | Fri
 | 65 | 2023-06-23 00:00:00 | Fri
 | 66 | 2023-06-30 00:00:00 | Fri
 | 67 | 2023-07-07 00:00:00 | Fri
 | 68 | 2023-07-14 00:00:00 | Fri
 | 69 | 2023-07-21 00:00:00 | Fri
 | 70 | 2023-07-28 00:00:00 | Fri
 | 71 | 2023-08-04 00:00:00 | Fri
 | 72 | 2023-08-11 00:00:00 | Fri
 | 73 | 2023-08-18 00:00:00 | Fri
 | 74 | 2023-08-25 00:00:00 | Fri
 | 75 | 2023-09-01 00:00:00 | Fri
 | 76 | 2023-09-08 00:00:00 | Fri
 | 77 | 2023-09-15 00:00:00 | Fri
 | 78 | 2023-09-22 00:00:00 | Fri
 | 79 | 2023-09-29 00:00:00 | Fri
 | 80 | 2023-10-06 00:00:00 | Fri
 | 81 | 2023-10-13 00:00:00 | Fri
 | 82 | 2023-10-20 00:00:00 | Fri
 | 83 | 2023-10-27 00:00:00 | Fri
 | 84 | 2023-11-03 00:00:00 | Fri
 | 85 | 2023-11-10 00:00:00 | Fri
 | 86 | 2023-11-17 00:00:00 | Fri
 | 87 | 2023-11-24 00:00:00 | Fri
 | 88 | 2023-12-01 00:00:00 | Fri
 | 89 | 2023-12-08 00:00:00 | Fri
 | 90 | 2023-12-15 00:00:00 | Fri
 | 91 | 2023-12-22 00:00:00 | Fri
 | 92 | 2023-12-29 00:00:00 | Fri
 | 93 | 2024-01-05 00:00:00 | Fri
 | 94 | 2024-01-12 00:00:00 | Fri
 | 95 | 2024-01-19 00:00:00 | Fri
 | 96 | 2024-01-26 00:00:00 | Fri
 | 97 | 2024-02-02 00:00:00 | Fri
 | 98 | 2024-02-09 00:00:00 | Fri
 | 99 | 2024-02-16 00:00:00 | Fri
 | 100 | 2024-02-23 00:00:00 | Fri
 | 101 | 2024-03-01 00:00:00 | Fri
 | 102 | 2024-03-08 00:00:00 | Fri
 | 103 | 2024-03-15 00:00:00 | Fri
 | 104 | 2024-03-22 00:00:00 | Fri
 | 105 | 2024-03-29 00:00:00 | Fri
 | 106 | 2024-04-05 00:00:00 | Fri
 | 107 | 2024-04-12 00:00:00 | Fri
 | 108 | 2024-04-19 00:00:00 | Fri
 | 109 | 2024-04-26 00:00:00 | Fri
 | 110 | 2024-05-03 00:00:00 | Fri
 | 111 | 2024-05-10 00:00:00 | Fri
 | 112 | 2024-05-17 00:00:00 | Fri
 | 113 | 2024-05-24 00:00:00 | Fri
 | 114 | 2024-05-31 00:00:00 | Fri
 | 115 | 2024-06-07 00:00:00 | Fri
 | 116 | 2024-06-14 00:00:00 | Fri
 | 117 | 2024-06-21 00:00:00 | Fri
 | 118 | 2024-06-28 00:00:00 | Fri
 | 119 | 2024-07-05 00:00:00 | Fri
 | 120 | 2024-07-12 00:00:00 | Fri
 | 121 | 2024-07-19 00:00:00 | Fri
 | 122 | 2024-07-26 00:00:00 | Fri
 | 123 | 2024-08-02 00:00:00 | Fri
 | 124 | 2024-08-09 00:00:00 | Fri
 | 125 | 2024-08-16 00:00:00 | Fri
 | 126 | 2024-08-23 00:00:00 | Fri
 | 127 | 2024-08-30 00:00:00 | Fri
 | 128 | 2024-09-06 00:00:00 | Fri
 | 129 | 2024-09-13 00:00:00 | Fri
 | 130 | 2024-09-20 00:00:00 | Fri
 | 131 | 2024-09-27 00:00:00 | Fri
 | 132 | 2024-10-04 00:00:00 | Fri
 | 133 | 2024-10-11 00:00:00 | Fri
 | 134 | 2024-10-18 00:00:00 | Fri
 | 135 | 2024-10-25 00:00:00 | Fri
 | 136 | 2024-11-01 00:00:00 | Fri
 | 137 | 2024-11-08 00:00:00 | Fri
 | 138 | 2024-11-15 00:00:00 | Fri
 | 139 | 2024-11-22 00:00:00 | Fri
 | 140 | 2024-11-29 00:00:00 | Fri
 | 141 | 2024-12-06 00:00:00 | Fri
 | 142 | 2024-12-13 00:00:00 | Fri
 | 143 | 2024-12-20 00:00:00 | Fri
 | 144 | 2024-12-27 00:00:00 | Fri
 | 145 | 2025-01-03 00:00:00 | Fri
 | 146 | 2025-01-10 00:00:00 | Fri
 | 147 | 2025-01-17 00:00:00 | Fri