Calculating age
 

How to calculate ages of employees for benefits enrollment given the date of
birth?
--
Joe S.

Hi
see your other post
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe S." schrieb im Newsbeitrag
...
How to calculate ages of employees for benefits enrollment given the
date of
birth?
--
Joe S.

Joe,

Use the DATEDIF function. E.g.,

=DATEDIF(birthdate,TODAY(),"Y")

For more information on DATEDIF, see
www.cpearson.com/excel/datedif.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Joe S." wrote in message
...
How to calculate ages of employees for benefits enrollment
given the date of
birth?
--
Joe S.

Hi

=DATEDIF(BirthDate,ReferDate,"Y") returns number of full years;
=DATEDIF(BirthDate,ReferDate,"M") returns number of full months;
=DATEDIF(BirthDate,ReferDate,"YM") returns remaining number of full months,
after full years are calculated;
=DATEDIF(BirthDate,ReferDate,"MD") returns remaining number of days, after
full months are calculated;

P.e. you can calculate an age string:
="Y:" & DATEDIF(BirthDate,ReferDate,"Y") & "; M:" &
DATEDIF(BirthDate,ReferDate,"YM") & "; D:" &
DATEDIF(BirthDate,ReferDate,"MD")

Arvi Laanemets


"Joe S." wrote in message
...
How to calculate ages of employees for benefits enrollment given the date
of
birth?
--
Joe S.