countif value in column based on date match in header

Hi,

Looking for a formula to count all occurrences in a column determined by match function on date in header.

I have names in column a, row 1 contains dates and row 2 sub headers booked and arrived. I would like to calculate how many y appear in a column based on the column determined by the match on the date in row 1 for booked and arrived and summarised i5 to k7 in a table.

Can someone please help?

Many thanks