Calculate age based on defined date

[spill-the-beans]

Hello all,

At the moment I have a rather clumsy way of calculating someone's age based on today.

B	C	D	E	F
date of birth	today	year	months	answer
06/05/2008 <tbody> </tbody>	=TODAY()	=IF(MONTH(TODAY())>MONTH(B2),YEAR(TODAY())-YEAR(B2), IF(AND(MONTH(TODAY())=MONTH(B2),DAY(TODAY())>=DAY(B2)), YEAR(TODAY())-YEAR(B2),(YEAR(TODAY())-YEAR(B2))-1))	=DATEDIF(B2,C2,"m")	=INT(E2/12)&" years "&MOD(E2,12) & " months"

<tbody>
</tbody>

I have 2 questions:

1: Does anyone know how I would be able to have just three columns (B: the date of birth, C: today, and F: the answer) rather than have extra columns D and E in order to work out the answer in F?

2: Is it possible to work out someone's age based on their date of birth and a defined date? So instead of date of birth to today, I could put a different specific date in column C and have another formula to work out how old that person was on that specific date?

If anyone could help, I would much appreciate this.

 

[Comfy]

Excel 2010
	A	B	C
1	06/05/08	04/03/14	5 Years, 9 Months, 26 Days
2	07/05/08	04/03/13	4 Years, 9 Months, 25 Days
Sheet1

Cell Formulas
Range	Formula
B1	=TODAY()
C1	=DATEDIF(A1,B1,"Y") & " Years, " & DATEDIF(A1,B1,"YM") & " Months, " & DATEDIF(A1,B1,"MD") & " Days"
C2	=DATEDIF(A2,B2,"Y") & " Years, " & DATEDIF(A2,B2,"YM") & " Months, " & DATEDIF(A2,B2,"MD") & " Days"

 

[spill-the-beans]

Thank you very much, that has helped so much