Hi,

I have a formula

=DATE(YEAR(A1),MONTH(A1)+1,DAY(14))

A1 = 24/11/12
Result = 14/12/12

Correct!

if A1 = 13/12/12

I need the result to return 14/12/12, not 14/01/13

Incorrect!


Please Help!