Automatic Date Increase by 12 Months

  • Thread starter Thread starter Steve 084
  • Start date Start date
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)?
 
hi,

This

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

or this

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to add 12 months to an existing date field 3
date range 11
Average with multiple conditions 4
Excel 2000 and date math 3
CALCULATE DUE DATE & RESTART DATE 4
Increment date by 12 months 3
Expanding Date formula 1
changed DOB to age, but if no DOB need cell to be empty. 4

Back
Top