Countifs for records older then set date.

Hello
I am looking for help on the countifs formula.
I have a sheet with many entries. I need to find entriers added before a specific date. NOTE: I don't have a date column in my sheet.
Here's the formula I am trying to use but its not working:
=COUNTIFS({NESV Tracker Range 1}, "EPC", <=DATE(2023, 1, 6))
Any help would be appreciated.
Answers
-
Hi @Cristian
In order for a formula to evaluate a date range, there would need to be a date column in the source sheet. In your instance, I would recommend adding (and then hiding) the system Created Date column to your sheet. This will automatically back-fill information into your current rows, adding a date to each row for when it was created.
Then you can use that as the Range in your COUNTIFS to evaluate for your date:
=COUNTIFS({NESV Tracker Range 1}, "EPC", {Created Date Column}, <=DATE(2023, 1, 6))
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!