HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
 

I have a list of birthdates on and excel spreadsheet. I can calculate their
ages in days, but how can I find out how many of these kids are 1, 2, 3, 4,
and 5 years old?

HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
 

if you dates are in column A from A1 to A100, then in B1 enter:
=DATEDIF(A1,TODAY(),"y") and copy down

Then =COUNTIF(B1:B100,1) will be the number of 1 yearolds
Then =COUNTIF(B1:B100,2) will be the number of 2 yearolds
Then =COUNTIF(B1:B100,3) will be the number of 3 yearolds
Then =COUNTIF(B1:B100,4) will be the number of 4 yearolds
--
Gary''s Student - gsnu200720


"fairly new to excel" wrote:

I have a list of birthdates on and excel spreadsheet. I can calculate their
ages in days, but how can I find out how many of these kids are 1, 2, 3, 4,
and 5 years old?

HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
 

=SUMPRODUCT(--(DATEDIF(A1:A100,TODAY(),"Y")=1))


"fairly new to excel" wrote:

I have a list of birthdates on and excel spreadsheet. I can calculate their
ages in days, but how can I find out how many of these kids are 1, 2, 3, 4,
and 5 years old?