calculating ages dates

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculating ages from dates

Calculating ages from dates

resolvedResolved · Low Priority · Version 2003

Jenny has attended:
Excel Intermediate course

Calculating ages from dates

If date of birth is given, and a further date, how can the age of the person at the further date be calculated?

RE: 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


 

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Server loaded in 0.13 secs.