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.