Calculating years
Posted by Sonny on December 30, 2000 8:39 AM
I'll try to make this sound intelligent even though I obviously am not. I want to have a simple list of Names followed by their Birthday and the current age (in years). In lotus, a while back, I was able to get the computer to use the current computer date, compare it to the birthday of the individual and then show the actual age (years only). I have been unable to do this in excel 2000. Can you provide the formula for doing this please? I have read the book and pulled down help files till I'm bleary eyed. Thanks.
Posted by Aladin Akyurek on December 30, 2000 9:18 AM
If you have in A1, e.g., 30-01-67, type in
B1 =TODAY() and in
C1 =YEAR(B1)-YEAR(A1)
Aladin
Posted by Celia on December 30, 2000 9:19 AM
Sonny
If the birth date is in A1, here's one way (needs Analysis Toolpak) :-
=DATEDIF(A1,TODAY(),"y")
If you need to have age in years/months/days :-
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"yd")&" days"
Celia
Posted by Celia on December 30, 2000 9:30 AM
Re: Correction
Correction.
The second formula should read :-
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"ym")&" days"
Celia
Posted by Celia on December 30, 2000 4:43 PM
Try Again
Sorry, it should be :-
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days"
Posted by Sonny on January 01, 2001 11:25 AM
Re: Try Again
Thanks Celia - Your formula works perfectly.
Sonny
Posted by Rick on March 01, 2001 12:46 PM
Try Again
Nice job Celia, btw, where did you come up with the formula? I didn't see it listed in Excel 97.
