How to add a certain amount of years to a date?

touque

Board Regular
Joined
Jan 22, 2009
Messages
93
In cell A I have a date (e. 22-Jan-16).
In cell B I have a number (ie. 10).
How do I make cell C return the cell A date plus the number in cell B in years? So it would return 22-Jan-26.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,746
Office Version
365
Platform
Windows
How about
=EDATE(A1,B1*12)
 

touque

Board Regular
Joined
Jan 22, 2009
Messages
93
Worked like a charm! Thanks guys!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,746
Office Version
365
Platform
Windows
Glad we could help & thanks for the feedback.
@Paul Ked
It's a nice little function, that is often overlooked.
 

Forum statistics

Threads
1,085,589
Messages
5,384,624
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top