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

Question

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?

lverret1230 · Answer

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

hansvogelaar · Answer

You need to enclose the second condition in parentheses too:
&nbsp;
=FILTER(InvoiceMain, (InvoiceMain[Date]&gt;='DATA- Monthly'!SL1)*(InvoiceMain[Date]&lt;='DATA- Monthly'!SM1))

lverret1230 · Answer

This worked! Thanks!&nbsp;

Forum Discussion

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

3 Replies

Resources