Need help making this formula recognize YEAR when filtering data

[Newtonus_Prime]

Hi All,

I have been using this formula for a while to filter a list of data from a different sheet and just realized that it isn't using the year to filter out last years data. Is it possible to edit this formula to make sure that the year that is currently in cell B2 is the only year that appears on this list?

=LET(v,FILTER(CHOOSECOLS(Table8[[SchedTime]:[Notes]],11,8,19,12,2,3,4,5,1,21,22), (DATE(B2,MONTH(Table8[Ship Date]),1)=DATE(B2,MONTH(A2&0),1))*(Table8[Job Value]>=C2),""),SORT(FILTER(v,INDEX(v,,1)<>""),7))

[6StringJazzer]

Try this change. Instead of combining the year from B2 with the date in Ship Date, extract the year from Ship Date:


=LET(v,FILTER(CHOOSECOLS(Table8[[SchedTime]:[Notes]],11,8,19,12,2,3,4,5,1,21,22), (DATE(YEAR(Table8[Ship Date]),MONTH(Table8[Ship Date]),1)=DATE(B2,MONTH(A2&0),1))*(Table8[Job Value]>=C2),""),SORT(FILTER(v,INDEX(v,,1)<>""),7))

[Newtonus_Prime]

That works! Thank you.

[6StringJazzer]

Glad it worked, thanks for the rep!