Okay, now I know how to calculate a person age using datedif, but I need to
know how to accumulate the attendance of a person.

I've set up 30 columns for a month and blank cell represent attending, "A"
as absent unexcused and "AE" as excused absent. Previously, I calculate the
attendance by taking 30 minus the appearance of A, and AE, ( I used countif
function to add up A and AE). But now that I have to categorize each
person's attendance by their age group, how can I ACCUMULATE each person
attendance?

WHAT IF, for example, one person birth date fall into the middle of the
month and need to move to the next age group, can Excel handle this type of
variable situation?

Is there anyone interested in solving this problem?

Thanks a millions for any clue?

GU
P.S. I'm really frustrated!!!!