ADD THREE YEARS TO A DATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to formate a whole column of dates to add three years to the
individual dates. I would like to copy that formula from someone without
figuring it all out. I need to do this to about 200 current dates, so i need
to get it done, quickly. my brain jurts, as i am not a math thinking person.
( ie fomulas etc
-I am also tired and the brain is not working on the left side. can someone
help me out?-
becky
 
For a date in A1 you could use

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

or using EDATE from Analysis ToolPak

=EDATE(A1,36)
 
Original date in A1
In another cell =Date(year(a1)+3,month(a1),day(a1))
best wishes
 
You must log in or register to reply here.

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

Excel Average dates help 0
Figure out date from total days in year 2
Calculating to add years - including leap year 4
formula to add six months to date 3
IF - Date falls between two dates, place here 3
Create dates for year, allow for leap year 8
Match Formula for three fields to produce result 5
Date expires in 2 years 2

Back
Top