calculate Age Year Month & day

  • Thread starter Thread starter shailendra joshi
  • Start date Start date
S

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
 
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
 
Back
Top