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

VLD

Hi,

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.

Paul Newcome

Try something like this:

=DATE(YEAR(TODAY()) + IF(TODAY()> DATE(2023, 07, 01), 1, 0), 07, 01)

Paul Newcome

Try something like this:

=DATE(YEAR(TODAY()) + IF(TODAY()> DATE(2023, 07, 01), 1, 0), 07, 01)