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" wrote:

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

"shailendra joshi" wrote:

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