Calculate years from today date

[webmax]

Hi,

How to calculate the years from today date.

Example today date is 08/11/2013 i want the date after 15 years

 

[Sajan]

Perhaps I am overthinking this... but when you say add 15 years, do you mean 8/11/2028 or something else that factors in leap years, etc.?

 

[rakeshsukumar]

Try this
Let say if A1 = 08/11/2013 then type in b1 as =DATE(YEAR(A1)+15,MONTH(A1),DAY(A1))

 

[SirJB7]

@Sajan
Hi!
Overthinking I guess... any value for years that isn't multiple of 4 would turn uncertain the calculation in days, and those that are then are equivalent to consider the normal no. of years (unless at a century change, exceptuating Y2K). Am I wrong?
Regards!