I have a spreadshett and am trying to calculate the age of people from the DOB. The formula that I am using is:-
=IF(B5="","",YEAR(B5)-YEAR(B12)) - B5 being todays date and B12 being the DOB.
but it miss show as 1 year older than it should. For example:-
It's someones birthday on 24/06/2009 but they are already showing as 32 when they are still 31.
How can I solve this?
Paul
=IF(B5="","",DATEDIF(B12,B5,"y"))
Will give you the years
=IF(B5="","",DATEDIF(B12,B5,"ym"))
will give you the months if you need them!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Have a look at Chips site
There is an excellent age calculation formula at the bottom of this page
http://www.cpearson.com/excel/datedif.aspx
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks