Thread: [Solved] Converting serial number to years, months and days
View Single Post
 
Old 02-12-2013, 05:59 PM
hannu hannu is offline Windows 7 Office 2007
Advanced Beginner
  
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default 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?
Reply With Quote