Calculating Age

Corrine · Nov 13, 2003

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 · Nov 13, 2003

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 · Nov 13, 2003

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 · Nov 13, 2003

=DATEDIF(A2,B2,"Y")

Birth date from age	2	Mar 10, 2008
Excel formula calculating age	4	Apr 28, 2008
How do I calculate age using a 12 digit social security number in MS Excel?	0	Mar 4, 2011
Calculating Date of next birthday	3	Dec 22, 2008
Age based on birthdate	2	Jan 23, 2009
Formula to group into Age Ranges	2	Apr 22, 2008
SQL script to solve problem	1	Jul 16, 2022
Calculating age with If statement	2	Oct 21, 2009

Calculating Age

Corrine

Chip Pearson

Guest

Guest

Ask a Question

Similar Threads