ExcelBanter - How do I convert a birth date to current age?

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

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

- - How do I convert a birth date to current age? (https://www.excelbanter.com/excel-discussion-misc-queries/194165-how-do-i-convert-birth-date-current-age.html)

Tracey

How do I convert a birth date to current age?

Rick Rothstein \(MVP - VB\)[_858_]

How do I convert a birth date to current age?

Give this formula a try...

=DATEDIF(A6,TODAY(),"y")

The DATEDIF function is not document, but this link covers it in detail...

http://www.cpearson.com/excel/datedif.aspx

Rick

All times are GMT +1. The time now is 01:02 PM.