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.
|