Increment dates automatically

[Marion25]

I have a spreadsheet that I use for scheduling due dates which i would like it to automatically update according to the spreadsheet date .

Can someone please help me with formulas to calculate the following:

Monthly due date - The payment date needs to be 7th of the month. I need the month to update according to the date of the spreadsheet.

Quarterly date due - The payment date needs to update to be either 25th of Aug, Nov, Feb and May according to the spreadsheet date

Quarterly date due- The payment date needs to update to occur on the following dates - 15th of Jan, April, July and Oct according to the spreadsheet date
Thanks

 

[Phuoc]

Book1
	A	B	C
1	Today	09/21/2021
2	Monthly due date	Quarterly date due1	Quarterly date due2
3	10/07/2021	11/25/2021	10/15/2021
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TODAY()
A3	A3	=LOOKUP(EDATE($B$1,1),DATE(YEAR($B$1),MONTH($B$1)+{0,1},7))
B3	B3	=LOOKUP(EDATE($B$1,3),DATE(YEAR($B$1),{2,5,8,11,14},25))
C3	C3	=LOOKUP(EDATE($B$1,3),DATE(YEAR($B$1),{1,4,7,10,13},15))