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