Hi

=DATEDIF(BirthDate,TODAY(),"Y")
returns age in full years.
=DATEDIF(BirthDate,TODAY(),"YM")
returns remaining (minus full years) age in months.
=DATEDIF(BirthDate,TODAY(),"MD")
returns remaining (minus full years and months) age in days.

NB! The function isn't fully correct (especially with "MD" parameter) for
some combinations of specific dates, but it's applicable generally.

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Brian" wrote in message
...
Hello:
I was wondering if anyone could help me with a function in excel. I need
to
be able to calc peoples ages into different cells.
For example:
Col B has the DOB
Col C I need the current Age with the current Date

Col D as a Date and I need it the calc the age from that date to the DOB

I need this ASAP. Can anyone help.
Thanks