| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Converting months to years
Hi, I used the nper function and the result is x months, what formula can i
use to convert that to x years, y months. simply dividing by 12 will give me 11.5 ie 11 and a half years. I want the answer to be 11 years, 6 months. any ideas? |
|
#2
|
|||
|
|||
|
One way:
=INT(A1/12) & " years, " & MOD(A1,12) & " months" In article , "kevin" wrote: Hi, I used the nper function and the result is x months, what formula can i use to convert that to x years, y months. simply dividing by 12 will give me 11.5 ie 11 and a half years. I want the answer to be 11 years, 6 months. any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| years and months | Excel Worksheet Functions | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
| Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
| Help with Years of Service formula.... | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
