Excel Birthdates and Age

  • Thread starter Thread starter David
  • Start date Start date
D

David

I need to produce a spreadsheet providing the current
ages of students - based on entering their date of birth
dd/mm/yy and returning their current age in years months
and days. I sure it is possible - but beyond me!!
David
 
Hi David!

Use:
=DATEDIF(A1,B1,"y") & " y " & DATEDIF(A1,B1,"ym") & " m " &
DATEDIF(A1,B1,"md") & " d"

You can put =TODAY() in B1 or replace B1 by TODAY()

For details of the mysterious DATEDIF function see:

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

But you might get some difficult to interpret results if you want the
age on 1st March of someone born 31st January it returns something
like:

9 y 1 m -2 d

Don't blame the function! Blame us having different numbers of days in
a month and the awkward time span of the Earth's orbit around the Sun.
--
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.
 
Back
Top