I have the exact same problem, but unfortunately these answers have not solved my problem. The date that appears on my spreadsheet is 31/12/00

I have variants of this formula that creates the dates in G column:

=DATE(YEAR(F4)+1,MONTH(F4),DAY(F4))

I tried adding the recommendations as an extra part, for example:

=DATE(YEAR(F4)+1,MONTH(F4),DAY(F4))&If(F4 = 0, "", F4)

It always brings back the answer of 366, and does not make the cell blank...

Any help?