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..
Answers
-
Do you have a date in the source sheet that shows when each item was closed?
-
@Paul Newcome, potentially I can add this.
Are you thinking of referencing this column in my formula and then adding <= of the last day of the month?
-
Its either that or you are going to have to incorporate a third sheet and use a copy row automation.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives