Calc'ing Age based on two dates

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

I have been working on a worksheet that calculates a
person's age based on two dates - ie. birthday and todays
date - by just subtracting the two dates.

Is it possible to get that age to be recognized as a
number not a date so it is usable as in other formulas?
Maybe I am approaching this from the wrong angle. Is
there a better way to calculate how old a person is based
on two dates?

Thanks
 
Hi Frank,
I am working in Excel '97. When I use the dateif function
Excel is automatically changing over to 'date:' I am sure
that it will work once I get on my home computer though
since it is Excel 2000. For now I think I can work the
VBA here.
Thanks for the help
 
Try:
DATEDIF(DateofBirth,Now(),"Y")

Replace DateofBirth with the actual date and this should return the persons
age

HTH
 
Hi Troy!

How do you want to have the age expressed?

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