Accrual Worksheet Next Pay date Formula

[ItalianPlatinum]

I am looking to put together a worksheet to help calculate interest accruals depending on user inputs. Before I can expand it out further I need a way to determine the last payment date and next payment date considering the date in B1. Those would be driven by the inputs in other cells. See below for XLBB next to the cells is what they should be in this case (semi-annual) If Quarterly then in this case it should read 7/17/24 & 10/17/24. If monthly then 7/17/24 & 8/17/24 and etc for the others. Would someone be able to assist with those two formulas?

The additional caveat to that is if the first coupon date hasn't occurred yet then the Last payment date should be = to the first coupon date (start date essentially). Most cases it doesn't matter, but in rare occasions it is needed. I tried to start with a simpler example. Thanks in advance.

Book1
	A	B	C	D	E	F	G
1	Date	8/8/2024
2	Security	AAABBB		A	ANNUAL	1
3	Shares	7,435,000		B	BI-MONTHLY	6
4	Rate	5.5%		D	DAILY
5	Fixed/Variable	F		F	EVERY 2 WEEKS	26
6	Accrual Method	30/360		M	MONTHLY	12
7	Payment Frequency	S		Q	QUARTERLY	4
8	Payment Month	1		S	SEMI-ANNUAL	2
9	Payment Date	17		T	SEMI-MONTHLY	24
10	Issue Date	1/17/2017		W	WEEKLY	52
11	1st Coupon Date	7/17/2017
12	Last Payment Date		7/17/2024
13	Next Payment Date		1/17/2025
14	Days in Period	0
15	Smoothing
16
17	Due at Pay Date	$ 204,462.50
18	Daily Accrual	#DIV/0!
19	Accrued to Date	#DIV/0!
20
Sheet1

Cell Formulas
Range	Formula
B14	B14	=B13-B12
B17	B17	=(B3*B4)/VLOOKUP(B7,$D$2:$F$10,3,FALSE)
B18	B18	=ROUND(B17/B14,2)
B19	B19	=ROUND((B13-B1+1)*B18,2)