Counting a date range
Hi all
I am trying to count dates in a column - so my column is a date column but does have text "Due" as well as dates - when action has been taken the guys type over the "due and enter the date
I have the formal counting the Dues but having issues counting anything that is a date
=COUNTIFS({Jan Actual Date 24}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))))
=COUNTIFS({Jan Actual Date 24}, ISDATE(@cell), {Jan Actual Date 24}, AND(DAY(@cell) = 31, MONTH(@cell) = 12, YEAR(@cell) = 2024))
Not sure where I am going wrong
Answers
-
At a quick glance, it looks like you have one too many parentheses at the end of your first formula. Try:
=COUNTIFS({Jan Actual Date 24}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
For the second formula, I think you could simplify this to:
=COUNTIF({Jan Actual Date 24}, DATE(2024, 12, 31))
Let me know how that goes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!