Forum Discussion
Help with filtering year & date within the same formula using the FILTER Formula ?
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...
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))
This worked! Thanks!