Counting Tasks Due this week
Hello - Im attempting to count the number of tasks due this week using the following formula:
=COUNTIFS([End Date]1:[End Date]50, =WEEKNUMBER(TODAY()))
I only get "0", back even when the [End Date] week number is equal to today. Any help with this would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!