Hello Team
I need to calculate count of countries within the date range of request received . I am using below formula but its throwing invalid operation error, could u please correct me where I am making mistake.
Current Formula: =COUNTIFS({Table 1 Range 1}, {Table 1 Range 30}, >=[Date Received From]32, {Table 1 Range 30}, <=[Date Received To]32)
Here, {Table 1 Range 1} - Column with Country Names
{Table 1 Range 30} - Date received column
[Date Received From]32 & [Date Received To]32 - Date Range to select
Pleas let me know if you need any further details
