Automatic Date Increase by 12 Months

S

Steve 084

I am a fairly new user. In field A1 I have the date 12/1/08. Is there a
formula that would automatically add "12" months to A1 and place the results
in A2 (12/1/009)?
 
M

Mike H

hi,

This

=DATE(YEAR(A1),MONTH(A1)+12,DAY(A1))

or this

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

Mike
 
Top