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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test if a date falls within a given range of dates in Excel? 6
How do I calculate age using a 12 digit social security number in MS Excel? 0
Subtracting sumed figures from the YR before 1
Error message needed if incorrect Date Of Birth (DOB) entered 4
Scrabble Value calculation for Welsh words 0
If Array EDATE formula help 7
Sum Values from different column 1
formula for calculating 401k if over or equal to 1 yr of service . 1

Back
Top