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

[lverret1230]

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?

[#2]

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

[#3]

You need to enclose the second condition in parentheses too:

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

[#4]

This worked! Thanks!