I am having a hard time wrapping my mind around what way I should start
working up some code to separate people by age on a spreadsheet.

I will have a list of say 10,000 people. Column H is date of birth. I
need to put those people into their age groups as totals on a second
page.

For example:

the age bands are
0-29
30-34
35-39
40-44
50-99

The mind warping problem is my if statement. I figure somehow I have
to do an if a person's age is between 0 and 29 then put in B2 on
sheet2. But how would I tell it to calculate it? This is something
that would be used once a month so would it be something like if
today's date minus date in column H = 30,31,32,33, or 34 then move to
sheet2 B3?

I have this feeling I am making this way more difficult than I need to
but I can't think of a simple way to do it.

Thanks in advance
Mary