View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.