View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fairly new to excel fairly new to excel is offline
external usenet poster
 
Posts: 1
Default 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?