Calculating age

[Joe S.]

How to calculate ages of employees for benefits enrollment given the date of
birth?

 

[Frank Kabel]

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

 

[Chip Pearson]

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

 

[Arvi Laanemets]

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