Calculating Age On Leaving Employment

[Phil M]

Hi, I want to show the age of our leavers when they left - by subtracting their date of birth from their last day of service. The 2 cells are formatted as UK dates and I want to show the result as their age in years when they left. Years and months would be nice, but years only will be enough.

Can anyone help please?

Thanks in advance.

 

[Von Pookie]

Would this work?

Book1
	A	B	C	D
1	Birthdate	Started	Ended	Age
2	12/11/1965	10/08/1990	18/01/2005	39years,2months,6days
Sheet1

The formula in D2 is:
=DATEDIF(A2,C2,"y") & " years, " & DATEDIF(A2,C2,"ym") & " months, " & DATEDIF(A2,C2,"md") & " days"

I grabbed it from here:
http://www.cpearson.com/excel/datedif.htm

 

[Phil M]

It sure does! Thanks ever so much. I'll keep the link too for future reference.

 

[rs2k]

Put your two dates in A1 and B1 and the formula in C1 (or change to suit your range)

=DATEDIF(A1,B1,"y")

will give you the difference in years.
Change the y to d and it will give you the result in days
Change the y to m and it will give you the result in months

Colin

 

[Phil M]

Thanks, I can see lots of uses for this.

 

[rs2k]

Phil, have a look at "Index to 485 articles" at the bottom of the page, theres loads of great stuff there.

Colin

 

[Von Pookie]

In that same vein, we have the 'Recommended Add-ins and Links' thread at the top of the forum as well

http://www.mrexcel.com/board2/viewtopic.php?t=49750

 

[Phil M]

You're not kidding! Hadn't spotted either before - my, I am going to be busy... Thanks both for the pointers.