Help with filtering year & date within the same formula using the FILTER Formula ?

Copper Contributor

So in this formula, I was pulling all my sales in the December. Now that its a new year, the formula is pulling of sales of December in 2023 & 2024. I've tried doing the FILTER function with multiple criteria {by using * or + or &} and filtering by year as well but I keep getting an error. Can anyone help me with this?




3 Replies

I just tried a different formula & it didn't pull the 2024 number anymore but i pulled very cell in 2023 instead of just December



You need to enclose the second condition in parentheses too:


=FILTER(InvoiceMain, (InvoiceMain[Date]>='DATA- Monthly'!SL1)*(InvoiceMain[Date]<='DATA- Monthly'!SM1))