Convert Months to Years and Months

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

DMumme

New Member
Joined
Jun 14, 2014
Messages
23
=INT(A1/12)&" years "&ROUND(((A1/12)-INT(A1/12))*12,0)&" months."
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,425
Office Version
365
Platform
Windows
Try:
Code:
=INT(A1/12) & " years " & MOD(A1,12) & " months"
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,425
Office Version
365
Platform
Windows
Never came across MOD before. Learn something new every day.
Yep, very useful function!
:)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,253
Messages
5,467,562
Members
406,543
Latest member
semoredhawk

This Week's Hot Topics

Top