| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a number into Years, Months, Days format?
I want to convert a number and display it as Number of Years, Months and
Days. eg 8548 converts into 23 Years, 4months and 24 days. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| convert number to date format | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| holiday dates | Excel Worksheet Functions | |||
Threaded Mode
