Odd bug in Date formula?

damon.tackett

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

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

Michelle Choate 2

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

damon.tackett

Thank you. That makes sense.