Need help with YEARFRAC

[leopardhawk]

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!

 

[Michael M]

So maybe this method then....

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

 

[leopardhawk]

Thank you so much Michael, that works perfectly! Cheers!

 

[Michael M]

Glad to help...thx for the feedback..