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)

"becky" wrote:

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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"becky" wrote in message
...
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