Hi,

I need a formula to count the number of cells in a table that have a specific age range e.g. 0-17. The cells all have the date of Birth in them, so I'm struggling to find a way to count among the whole group while also converting birth date to current age in a formula. The formula below didn't seem to work (for cells with an age of 25)

=COUNTIF($E$3:$E$16,(DATEDIF($E$3:$E$16,TODAY(),"Y")=25))

Thanks in advance!