Question

So here is something I have been trying to tweek with no success….

I have this column formula which takes the date in column A and gives me the updated date of same month, last day + 2 yrs (ie 11/01/24 becomes 11/30/26)

=DATE(YEAR([Appointment Month]@row) + 2, MONTH([Appointment Month]@row) + 1, 1) - 1

and it works great for every month except December.  I am assuming the year changing the next month has something to do with it but I can't figure out the tweek to capture that.

Michelle Choate 2 · Accepted Answer

It is MONTH([Appointment Month]@row) + 1  part of your formula that is throwing you off. Because you are asking it to take the month and add 1. There is no 13th month, hence the error