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.

[TABLE="width: 1000"]
<tbody>[TR]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]date of birth[/TD]
[TD]today[/TD]
[TD]year[/TD]
[TD]months[/TD]
[TD]answer[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="class: xl65, width: 75, align: right"]06/05/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]=TODAY()[/TD]
[TD]=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))[/TD]
[TD]=DATEDIF(B2,C2,"m")[/TD]
[TD]=INT(E2/12)&" years "&MOD(E2,12) & " months"[/TD]
[/TR]
</tbody>[/TABLE]

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