Age Calculation

  • Thread starter Thread starter Muntasar
  • Start date Start date
M

Muntasar

I want to calculate my age in MS Excel Sheet. Is it
possible? For example : My birth date is 12-12-1960, today
is 26-08-2003. How old am I, today ? I want to insert
today's date in cell A1 and my birthdate in cell B1, then
what will I write in cell C1 to find out my age?

Let me know please.

Thanks
 
No! This function was intended for calculating time spans of less than one year (note the name),
and is more specifically intended for things like financial calculations of accrued interest,
etc. Without the 3rd argument, you are assuming 30 day months and 360 days per year. Even
setting 3rd argument to 1, you'll get errors when the 2nd date is very close to the anniversary
of the birthdate. And you get different results for different years.

Without the 3rd argument, if birthdate is 2/28/1968, and 2nd date is 3/1/2003, YEARFRAC gives
35.00833. Now change the years to 1969 and 2004, respectively. You should get the same result,
right? But you don't -- it's 36.00278.

A better function for this purpose is DATEDIF, i.e. =DATEDIF(B1,TODAY(),"y"), which gives the
age in whole years.
 
I've try as per your formula. But failed. Pls. let me know
why? My e-mail address : (e-mail address removed)

Thanks
 
Muntasar:
Try this:
=DATEDIF(A18,NOW(),"y")&" Years,"& DATEDIF(A18,NOW(),"ym")&"
Months,"&DATEDIF(A18,NOW(),"md") &" Days"
Subtract any part of the equation you want.
Hope that helps. I got it from one of the fellows in the newsgroups, but
don't remember who.

--
Wayne
"Friendship through radio"
Muntasar said:
I am a new learner. Please give me the easiest way/tips!
Thanks
MA
-----Original Message-----
I see a typo. The 2nd result is 35.00278, not 36.00278.


spans of less than one year (note the
name),
Click to expand...
Click to expand...
Click to expand...
 
Back
Top