Comuting someones age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
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?
 
Back
Top