Date addition .

[s_ojha]

I want to add years in dates . The answer returned should be by adding the number in four digit year number not the day. For eg:
25/08/1994
30/06/1998
In the above dates, I want to add "5" in the year and want to copy the formula in rest of the other records . The answer returned should be by adding 05 in the year and not in day.
Please help

 

[gnaga]

Assuming your date records are in Column A, In Column B enter this formula and copy down

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

GNaga

 

[fairwinds]

Hi,

Try:

=EDATE(A1,12*5)