Try:
=SUMPRODUCT((B2:B97<--"30/05/1976")*(B2:B97--"30/05/1966"))

Cheers,
--
AP

"ExcelDummie" a écrit dans le
message de news: ...
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")