Automatic quarterly date change

I have city bills due every quarter so I went to create a date that will automatically change for their due date.
Fit example my first trash bill this year was due February 17, 2021 so the next due date was May 17, 2021 and after that August 17, 2021. Based on the current date May 4, 2021 it should say August 17, 2021..... And then automatically change after that based on whatever the current date is..,... Does that make sense?

Sent from my Pixel 5 using Tapatalk

Why should it say that the next date is in August on 04 May when 17 May has not yet passed?

AliGW said:

Why should it say that the next date is in August on 04 May when 17 May has not yet passed?

Click to expand...

Well true that was a mistake it should say may 17 now but after that it should say August 17

Sent from my Pixel 5 using Tapatalk

If cell D7 contains the date of a past bill, then in any other cell:
=EDATE(D7,3*(QUOTIENT(DATEDIF(D7,TODAY(),"M"),3)+1))
will give you the date of the next bill after today.
On the date of the next bill, the value will flip to the next one.
I'm sure it could be more elegant, but it's the first one that worked.