Formula to COUNTIF with respect to the date column
These two formula are not working - ERROR - #unparseable. The solution I am looking for is to count the no. of MOUs in a calendar year (YTD 2023).
=COUNTIFS({MOU Status}, "Active", {Date of execution}, (@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 12, 31)))
=COUNTIFS({MOU Status}, "Active", {Date of execution}, >=DATE(2023, 1, 1), {Date of execution}, <=DATE(2023, 12, 31)))
Please help and suggest an alternative solution.
Answers
-
Hi @SiddV47,
You just need to add an AND function to the first formula as you have 2 date criteria:
=COUNTIFS({MOU Status}, "Active", {Date of execution}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 12, 31)))
The # unparseable error is being caused as without the AND the 2nd date criteria is being read as a range (which it isn't), lacking any criteria.
Hope this resolves your issue, but if not let us know!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!