How do I find age in years from anniversary date (Age funtion)?

E

Enquire

I need to calculate age given birth-date.

First, I tried
=YEAR(NOW())-YEAR(cell ref with birthday)

This works, but (of course) the resulting year rolls-over on January 1, not
on the actual birthday.

I searched for "Age function" but (aside from Access) the closest I could
find was:

"How to calculate ages before 1/1/1900 in Excel" (Q245104)

http://support.microsoft.com/kb/245104/en-us

Well, I am not dealing with dates before 1900, but I tried it anyway (even
though I could not believe I needed a VB script to do this)

I created the VB script "AgeFunc" and then adapted the formula

=AgeFunc(startdate,enddate)

to

=AgeFunc(YEAR(NOW()),YEAR(AE353))

Where AE353 is the cell reference with the birth-date.

However, this returned the error #VALUE!

This is such a basic function ... one of the first "functions" that toddlers
understand ... how come I can't do this in Excel?!?

Surely there is a built-in "AgeFunc" in Excel ... can anyone help?!?

Thanks in advance
 

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
Excel - Calculate age from DOB in years, months days 7
create calculated field for age in pivot tables 4
How do I put in a formula in Exel to calculate a persons age? 11
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
"how do I calculate age by using date of birth details" 6
Age 9
calculate average values for 100 records in the shortest way? 5

Top