Need help with YEARFRAC

leopardhawk

Active Member
Joined
May 31, 2007
Messages
407
Office Version
2016
Platform
Windows
Hello forum friends, would like to know if it's possible to convert a decimal to months of age. I have a formula that is returning "Started pension at 63.5222222222222 years of age" and I think it would look a lot better if it returned "63 years 6 months of age". The return does not need to include the number of days.

Any help greatly appreciated.

Formula:

="Started pension at "&YEARFRAC(E5,H5)&" years of age."

Thank you!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,778
Office Version
2013
Platform
Windows
So maybe this method then....

Code:
="Started pension at "&DATEDIF(E5,H5,"y")& " Years " &DATEDIF(E5,H5,"ym")&" months of age."
 

leopardhawk

Active Member
Joined
May 31, 2007
Messages
407
Office Version
2016
Platform
Windows
Thank you so much Michael, that works perfectly! Cheers!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,778
Office Version
2013
Platform
Windows
Glad to help...thx for the feedback..(y)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,934
Messages
5,447,396
Members
405,450
Latest member
JamesLH

This Week's Hot Topics

Top