COUNT IF function when dates are in column

Hi
I am trying to create an excel with various rows and column.
The dates will be in column.
I want to count all the "Y" fall between two date range.
I have attached simple data table
A1 to T2 data table.
C7 and E7 date range
I want the total no of Y to be generated in B9

Thank you for your kind assistance

Found one I could help with but I was too slow!

Originally Posted by FDibbins

Try this...
=COUNTIFS($A2:$T2,"y",$A$1:$T$1,">="&$C$7,$A$1:$T$1,"<="&E7)

Many thanks FDibbins!

Originally Posted by FDibbins

cricket, dont let that stop you just because someone has posted a suggestion, doesnt mean that is whatthe OP wanted, or that even if it is, it's always possible there could be a better way to do it

Thanks FDibbins. In this case the solution I came to was effectively identical to yours so I didn't bother but I take your point!