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

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).

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

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

jan wrote:
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).