Simple formula to increase the date by 12 months, or 1 year less one day

PeterLatcapital

Hello,

I have played with this until my brain is numb.

=DATE(YEAR(Entry@row) + 1, MONTH(Entry@row), DAY(Entry@row) -1)

PeterLatcapital

I got it!

=DATE(YEAR(Entry@row) + 1, MONTH(Entry@row), DAY(Entry@row) - 1)

Thank you for looking

Genevieve P.

Hey @PeterLatcapital

Glad you got it working! 🙂