Sorry, but no cigar! <g>
Dividing by 365 isn't correct: some years have 366 days. The older the person,
the bigger the error due to this problem. After 60 years, you are off by ~15
days. Mod 30 also isn't correct: some months have 31 days, February 28 or 29.
Today is 25 Oct 2004. Using a birthdate of 25 Oct 1954, your formula gives 50
years and 13 days. Should be 50 years, 0 months, 0 days.
Why not just leave the birthdate alone and use DATEDIF for the entire formula?
I realize this is harder without the documentation for DATEDIF and knowledge
of all the possibilities for the 3rd argument. Nevertheless,
=DATEDIF(A2,TODAY(),"y")&" years, "&DATEDIF(A2,TODAY(),"ym")&" months and
"&DATEDIF(A2,TODAY(),"md")& " days"
With the date 25 Oct 2004 in A2, that gives the correct age. But even DATEDIF
has problems when the one or both of the dates are close to the end of the
month, and the 2nd is close to the birthday.
=QUOTIENT(A1,365) & " years, " & QUOTIENT(MOD(A1,365),30)
& " months and " "IENT(MOD(MOD(A1,365),30),1) & " days"
Where A1 is how old you are in days from:
[birthdate][=TODAY()][=DATEDIF(Birthdate cell,Today()
cell,"d")]...goes into A1
-----Original Message-----
I work with student data in public schools, and want to
have the spreadsheet
maintain the actual student age based on birthdate. What
formula should be
used to make this occur?
Thanks.
.