| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
converting months to years and months???
I have used the following formula to work out the difference between two days
and it provides me an answer in months. =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3) However if the difference is 15 months, how do i convert this to read 1 year and 3 months? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
| Converting months to years | Excel Worksheet Functions | |||
| years and months | Excel Worksheet Functions | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Threaded Mode
