calculate age from 2 dates in yy,mm,dd format in excel

J

jan

In excel 2003, how do I claculate age from date of birth and another date. I
would like to express this in yy,mm,dd format (I've already formated the cell
to appear this way).
 
P

Pete_UK

Try this, with dates in A1 and B1, B1 being the later date (could be
=TODAY() ):

=DATEDIF(A1,B1,"y") & "," & DATEDIF(A1,B1,"ym") & "," &
DATEDIF(A1,B1,"md")

As this returns a string, your cell format is not relevant, though I've
tried to match it.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
Date Format 10
How to enter a date in DD-MM-YYYY format 2
Change date format in Excel footer 2
calculate average values for 100 records in the shortest way? 5
converting dd/mm/yy to mm/dd/yyyy 3
Date format in Excel 2007 mm/dd/yy not appearing correctly 2

Top