Calculating age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to calculate ages of employees for benefits enrollment given the date of
birth?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate age as of a date certain 1
How do I calculate a persons age from birth dates 1
How do I calculate a person's age from date of birth and a date 2
Calculate age 3
Calculating When Somebody Reaches a Certain Age 4
Exclude blank data from formula calculation 3
Calculate age as of a given date 1
date of birth age formula 8

Back
Top