Countifs based on current week

[SplatP1]

Hello,
I need a formula to return the countif based on the current work week (starting on a Monday).
My data looks like this:

Weekly Activity <tbody> </tbody>	Total Activity <tbody> </tbody>	Date <tbody> </tbody>	03.08.2018 23:00:00 <tbody> </tbody>	03.08.2018 15:00:00 <tbody> </tbody>	02.08.2018 17:00:00 <tbody> </tbody>	01.08.2018 13:00:00 <tbody> </tbody>	01.08.2018 21:00:00 <tbody> </tbody>	26.07.2018 01:00:00 <tbody> </tbody>	26.07.2018 23:00:00 <tbody> </tbody>	20.07.2018 14:00:00 <tbody> </tbody>
3	6				Y	Y	Y	Y	Y	Y
2	6		Y	Y		Y		Y	Y	Y
2	5			Y	Y		Y		Y	Y

<tbody>
</tbody>

The formula must check that a date in A4:A8 is in the current work week, and return the count of "Y" in the corresponding columns below those that are, to cell A1. In this case, there are 3 "Y" in the current work week (30.07 - 05.08) in row B

Thanks in advance!

Owen

 

[SplatP1]

bump