Excel formula to calculate age

T

Tim

I hope there is an easy formula in Excel that will calculate a person's
age given their date of birth. And update that age when next the
spreadsheet is opened.

thanks
Tim
 
J

J.E. McGimpsey

Tim said:
I hope there is an easy formula in Excel that will calculate a person's
age given their date of birth. And update that age when next the
spreadsheet is opened.
Click to expand...

One way:

A1: <dob>
B1: =DATEDIF(A1, TODAY(), "y")

DateDif is not documented in any XL version other than WinXL2000.
For an explanation of the function and its options, see

http://cpearson.com/excel/datedif.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
New computer, how do i move outlook 365 ENTIRELY? 0
Calculating age from date of birth and ignoring if blank 3
Add additional information to excel form after original data entry 0
calculate average values for 100 records in the shortest way? 5
How do I calculate a person's age from date of birth and a date 4
Calculate age 3
Search Sheet Names Across Excel Files 0

Top