Age based on birthdate

S

Squid

I am using Excel 2007 and seems the DATEDIF function is no longer available.
What is the formula to calculate ones age based upon a birthdate.

The following formula does not seem to work (if today is 11/14/2008 and
birthdate is 11/13/1958, it results in 55, instead of 54):

=YEAR(Today()) - YEAR(A2)

Thanks
 
F

Fred Smith

Datedif works in my XL2007. But if you can't, or won't, use Datedif, you can
easily check to see whether the person has had a birthday this year, as in:
=YEAR(TODAY())-YEAR(A2)-(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))>TODAY())

Regards,
Fred
 

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

Excel formula calculating age 4
Help: Formula for calculating Baseball League Age? 4
How do I calculate age from birthdate to present in Excel? 4
date of birth age formula 8
Age Formula 15
How can I compute a kids age based on his birthdate 5
How to display an age in query based on Datediff expression in a f 2
calculating age based on birthdate 19

Top