I'm stuck on a date formula that will work. I'm building a spreadsheet where the user can enter a date and the spreadsheet will calculate the monthly payment dates. I need help with the below example where the date entered is 7/29/2022 and when it gets to March of 2023, it is picking up the 28th day from the cell right above. I need a formula that will work in tis situation for months with less than 30 days so every month that has in this example has 29 days shows the 29th day of the month and not change to the 28th day after a February month.
Thank you for your help.
PD Calculator.xlsx | |||
---|---|---|---|
F | |||
11 | 7/29/2022 | ||
12 | 8/29/2022 | ||
13 | 9/29/2022 | ||
14 | 10/29/2022 | ||
15 | 11/29/2022 | ||
16 | 12/29/2022 | ||
17 | 1/29/2023 | ||
18 | 2/28/2023 | ||
19 | 3/28/2023 | ||
20 | 4/28/2023 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F11 | F11 | =IF($D$7="Y",F4,D4) |
F12:F20 | F12 | =IF($A12="","",EDATE(F11,1)) |
Thank you for your help.