Converting serial number to years, months and days

macropod · #7 02-14-2013, 09:21 PM

Quote:

Originally Posted by hannu

my second email is still searching for a simple answer to the problem of displaying the age of a person in years, months and days, when the DOB and todays date are known.

That is what the formula I posted solves, where the DOB is in A1 and today's date is in B1. Of course, if you don't want to have today's date in B1, you could use:
=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months & "&DATEDIF(A1,TODAY(),"MD")&" days"

Similarly, if you had only a number of days in B1, without knowing the DOB you could get an approximation with:
=DATEDIF(0,B1,"Y")&" years, "&DATEDIF(0,B1,"YM")&" months & "&DATEDIF(0,B1,"MD")&" 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