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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!