Forum home » Delegate support and help forum » Microsoft Excel Training and help » Age Calculator

Age Calculator

ResolvedVersion 2003

Thu 17 Dec 2009, 10:43 Delegate Paul said...

Paul has attended:
Excel Intermediate course
Excel Advanced course

Age Calculator

Hi,

Could you help me set up a simple Excel template that will calculate a person's age in years and months based on today's date?

Thu 17 Dec 2009, 14:58 Trainer Stephen said...

RE: Age Calculator

Hi Paul

Thanks for your question

I have created a simple workbook, that uses the datedif() function to calculate the total number of years and total number of months since the birthdate.

It then combines them to calculate the nuimber of years and the balance of months

Hope this is useful

Regards

Stephen

Attached files...

Age Calculator.xls

Tue 29 Dec 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

Age Calculator

Age Calculator

RE: Age Calculator

Attached files...

Excel articles

Excel tip:

Difference between Two Dates