Date Formula

[RLJ]

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.

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.

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about in F12 copied down

=IF($A12="","",EDATE(F$11,ROWS(F$12:F12)))

 

[RLJ]

Thank you. It looks like the formula works. Also, I will update my profile. It has been a while since I have asked a question on here.

 

[Fluff]

You're welcome & thanks for the feedback.