|
|
#1
02-12-2013, 05:59 PM
|
|||
|
|||
Converting serial number to years, months and days
I have a serial number representing a person's age say 12,345 days in cell B1. what is the formula to convert (or display) that in years months and days?
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I get auto-updated "number of days since specified date" on MS word?
|
terry795 | Word | 16 | 01-07-2016 04:33 PM |
|
Increase serial number for every print
|
atomtm | Word | 1 | 06-15-2012 05:39 AM |
|
Serial Number Issue
|
rehan5001 | Excel | 1 | 06-08-2011 02:46 AM |
| Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |
| Help needed using the serial number date with sumifs - whole office is stumped | FraserKitchell | Excel | 3 | 01-06-2010 12:24 PM |
Windows 7 
Office 2007
Threaded Mode