| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a number into Years, Months, Days format?
Agreed <g.
8548 returns: 23 years, 5 months and 27 days It was just an "approx." thought thrown in here. I didn't want to get involved in the intricasies. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kassie" (Change all to lowercase) wrote in message ... True, except that that will give you 27 days, and not the 24 that the Op wants ;-) -- Hth Kassie Kasselman |
| 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
