Calculating Age

[Corrine]

Does anyone know how to calculate age from using the
persons birthdate? I would do it by hand but I need to
calculate over 1500 employees!

 

[Chip Pearson]

Corrine,

See the "Calculating A Person's Age" section at
www.cpearson.com/excel/datedif.htm for an example formula.


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

 

[Guest]

Thanks a million!

-----Original Message-----
Corrine,

See the "Calculating A Person's Age" section at
www.cpearson.com/excel/datedif.htm for an example formula.


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





.

 

[Guest]

=DATEDIF(A2,B2,"Y")