Calculating ages from dates

Hello Jenny

Thank you for your question and welcome to the forum.

You can use a function called Datedif to do this calculation for you. It's a weird little function because you won't find it in the Insert Function dialogue box, it has to be input manually (typed) into a spreadsheet.

So you will need to have both dates in the spreadsheet in different cells. For example say you have the DOB in A1 and the second (further) date in cell B1.

Then type the function into a separate cell:
=datedif(A1,B1,"y")

The syntax (structure) of the function is as follows:
=datedif(start date,end date,unit)

where start date is the earlier of the two dates;
end date is the latter of the two dates;
and unit is the measurement of time (days, months, years) that you want the result to be displayed in. Further explanation of the units you can use can be found here:
http://www.ozgrid.com/Excel/calculate-age.htm

I hope this helps.

Kind regards
Amanda