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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!