COUNTIF as of Today?


Hi, I have a sheet I'm using to calculate the number of open tasks on my project.

=COUNTIFS({Corporate MOC Location}, CONTAINS("BER", @cell))

The reference sheet is constantly being updated as and when actions are completed.

I want to cell link this count to my KPI sheet to track the performance of the team over the course of the year. e.g how many open actions were left open in July, August, etc.

Is there a way of adding to my formula to only make it look at the number of open tasks up to the last day of the month.

I'm probably overthinking this..