Comuting someones age

  • Thread starter Øyvind Alsos
  • Start date
Ã

Øyvind Alsos

I have a problem computing a persons age.
I cannot find a suitable function that solves my problem.

"YEAR(TODAY())-YÈAR(dateOfBirth)" returns the number of years between this year and the year of birth. Not the actual age

Does anybody know how I can compute the actual age so that "06.feb.2004 - 06.feb.1974" gives "30" years old and "06.feb.2004 - 07.feb.1974" gives "29" years old?
 
N

Norman Harker

Hi Øyvind!

Try:
=DATEDIF(A1,B1,"y")

Returns the completed years between start_date in A1 and end_date in
B1

For details of DATEDIF see:

Chip Pearson
http://www.cpearson.com/excel/datedif.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Øyvind Alsos said:
I have a problem computing a persons age.
I cannot find a suitable function that solves my problem.

"YEAR(TODAY())-YÈAR(dateOfBirth)" returns the number of years
Click to expand...
between this year and the year of birth. Not the actual age
Does anybody know how I can compute the actual age so that
Click to expand...
"06.feb.2004 - 06.feb.1974" gives "30" years old and "06.feb.2004 -
07.feb.1974" gives "29" years old?
 
Top