calculate Age Year Month & day

[shailendra joshi]

my bdate 14-10-1979
to day 06-09-2008

to day my age is 28 year 10 month & 23 days
how to calculate in excal 2007 this formate

 

[Sheeloo]

Try =DATEDIF(BirthDate,TODAY(),"y")&" years
"&DATEDIF(BirthDate,TODAY(),"ym")&" months
"&DATEDIF(BirthDate,TODAY(),"md")&" days"

For details and source of this go to
http://www.cpearson.com/excel/datedif.aspx

 

[Mike H]

Hi,

And this can all go pear shaped with an unfortunate combination of dates.
Consider a birthday of

31/1/1980
and a calculation done on
1/3/2008

You will find your formula returns
28 years 1 months -1 days


Mike

 

[Sheeloo]

I got 28 years 1 months 1 days
with the dates you mentioned.