ExcelBanter - How can I calculate age using a birth date in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I calculate age using a birth date in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/37531-how-can-i-calculate-age-using-birth-date-excel.html)

Gerald

How can I calculate age using a birth date in Excel?

Bob Phillips

See http://www.cpearson.com/excel/datedif.htm#Age

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Gerald" wrote in message
...

Ltat42a

Gerald Wrote:
How can I calculate age using a birth date in Excel?

I use - =INT((TODAY()-A17)/365.25)

A17 is my date of birth

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=390961

All times are GMT +1. The time now is 09:22 PM.