Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to display numbers as Years and Months in Excel

No comments
Given a decimal number of 7.69, how will you get its Years and Months equivalent?. This was the problem raised by a colleague and the excel formula for it is:

=INT(A1) & " years / " & INT((A1-INT(A1))*12) & " months"

Where A1 is the cell contains the decimal number to convert.

So using the formula above, 7.69 = 7 years / 8 months

No comments :

Post a Comment