Automatic updating of age groups columns
 

nUsing XP Home/ Office 2000.
I have two colums of students, column 'A' contains D.O.B, column 'B''
contains students age.
Has anyone a formula so that Column B will automatically update the students
age rather than having to manually update the current age of each student?
Thanks in advance.

Automatic updating of age groups columns
 

One way:

B2: =DATEDIF(A2,TODAY(),"y")

In article ,
Paul JJ Adams wrote:

nUsing XP Home/ Office 2000.
I have two colums of students, column 'A' contains D.O.B, column 'B''
contains students age.
Has anyone a formula so that Column B will automatically update the students
age rather than having to manually update the current age of each student?
Thanks in advance.

Automatic updating of age groups columns
 

Maybe this in b1 and drag down

=DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
DATEDIF(A1,NOW(),"md") & " d"

Mike

"Paul JJ Adams" wrote:

nUsing XP Home/ Office 2000.
I have two colums of students, column 'A' contains D.O.B, column 'B''
contains students age.
Has anyone a formula so that Column B will automatically update the students
age rather than having to manually update the current age of each student?
Thanks in advance.

Automatic updating of age groups columns
 

Note that this produces some weird results...

For instance on 3/1/2008:

A2: 1/31/1990
B2: 18 y, 1 m, -1 d


Also - never need to use NOW() rather than TODAY() - the time portion
just gets thrown away.


In article ,
Mike H wrote:

Maybe this in b1 and drag down

=DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
DATEDIF(A1,NOW(),"md") & " d"

Automatic updating of age groups columns
 

Thanks for that, I never new about the spurious results

"JE McGimpsey" wrote:

Note that this produces some weird results...

For instance on 3/1/2008:

A2: 1/31/1990
B2: 18 y, 1 m, -1 d


Also - never need to use NOW() rather than TODAY() - the time portion
just gets thrown away.


In article ,
Mike H wrote:

Maybe this in b1 and drag down

=DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
DATEDIF(A1,NOW(),"md") & " d"