How to calculate Age

[Centrol]

If one keys in his birthday, how can Excel calcuate his age based on:

- age today
- age next birthday
- age nearest birthday

Any help appreciated. TIA

 

[Guest]

C1 =
=DATEDIF(A1,B1,"y")

should get you started (a1 = Birth date), (b1 = Today())

HTH

Jim May

 

[JW]

If one keys in his birthday, how can Excel calcuate his age based on:

- age today
- age next birthday
- age nearest birthday

Any help appreciated. TIA

Have a look here:
http://www.exceltip.com/st/Working_Out_a_Person's_Age_in_Microsoft_Excel/634.html

 

[Guest]

=DATEDIF(B11,NOW(),"y") & " years, " & DATEDIF(B11,NOW(),"ym") & " months, "
& DATEDIF(B11,NOW(),"md") & " days"

which I got from somewhere <smile> - if my memory was not Swiss cheese I
would acknowledge!

 

[Guest]

Hi,

Did you ever take one of my classes? I use that exact example in a couple
of them.

Now - Age next birthday:
=DATEDIF(D6,TODAY(),"y")+1 where D6 contains your birthday.

Age nearest birthday is more of a problem because you haven't told us what
to do with a date that is half way between the last and next birthday.
However, the following works pretty well:
=DATEDIF(D6,TODAY(),"Y")+IF(DATEDIF(D6,TODAY(),"yd")>365/2,1) again D6
contains your birthday.