How can I update a date cell to change to the following year automatically?



Hoping someone can assist.

I have a sheet with automations built in. Basically, a form is sent out on each respective date and then the QTR column updates to the next QTR. So Q2 date reached, form sent and QTR column updates to Q3.

What I want to know - Is there any way I can then have my Q2 date updated to 01/07/24?

Below is an snippet of my sheet if it helps.

Thank you in advance.

Best Answer