ADD THREE YEARS TO A DATE

B

becky

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
 
D

daddylonglegs

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)
 
B

Bernard Liengme

Original date in A1
In another cell =Date(year(a1)+3,month(a1),day(a1))
best wishes
 
Top