I am working on an active google spreadsheet and i am in need to to count specific categories for cases in each month
Right now i have the follow sheet setup B(issue date),C(unit),F(category) and B(check in),C(unit),I(category),L(check out) These are in different tabs but for stats and records i need to keep count of cases and categories in specific months.
I have tried using : =query('sheet'!$B:$F, "select C,D,F where C>='9/1/2021' and C<='9/30/2021 group by C' ", 1)
But it just gives me the header and it mentions that the result is empty
Is there any way to keep an automatic count of cases in specific months or do i need to make new tabs for each month?
Any ideas are appreciated.
Test file here :