View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ExcelDummie ExcelDummie is offline
external usenet poster
 
Posts: 1
Default Counting dates....

Trying to do a calculation to count the number of people who are aged between
30 and 40 have their dates of birth in a table trying to get the formula to
work because it has to be greater than one date AND smaller than another????

=COUNTIF(B2:B97,"<30/05/1976",=30/05/1966")