Date of birth and ages

[JennyB]

If I have today's date in 1st cell and date of birth in 2nd cell, how do I get 3rd cell to show age?
Help please

[Aladin Akyurek]

On 2002-05-26 12:49, JennyB wrote:
If I have today's date in 1st cell and date of birth in 2nd cell, how do I get 3rd cell to show age?
Help please

In C2 enter:

=DATEDIF(B2,A2,"y") or

=YEARFRAC(B2,A2)

where B2 houses a bith date and A2 the formula =TODAY().

For YEARFRAC, you need the Analysis Toolpak add-inn that you can activate via Tools|Add-Ins.

[Paul B]

You could also use this to return the time in years months and days, with B4 having the birthday and B3 having the formula =Today(). Change cell references as needed

=DATEDIF(B4,$B$3,"y")&"y,"&DATEDIF(B4,$B$3,"ym")&"m,"&DATEDIF(B4,$B$3,"md")&"d"

[JennyB]

Many thanks, problem solved!

[dimrod]

On 2002-05-26 13:12, Paul B wrote:
You could also use this to return the time in years months and days, with B4 having the birthday and B3 having the formula =Today(). Change cell references as needed

=DATEDIF(B4,$B$3,"y")&"y,"&DATEDIF(B4,$B$3,"ym")&"m,"&DATEDIF(B4,$B$3,"md")&"d"

Be wary about using this sort of formula.
You might not always get the sort of results you expect.

For example for someone born on 1 Mar 1950, the age on 1 Jun 2002 produced by the formula will be 52y-3m-0d

However, for somenoe born 1 day earlier on 28 Feb 1950, the age will be 4 days older (instead of 1 day) at 52y-3m-4d