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.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,587
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
40,587
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,981
Messages
5,465,805
Members
406,449
Latest member
malar11567

This Week's Hot Topics

Top