Forum Discussion

JimCarr's avatar
JimCarr
Copper Contributor
Mar 16, 2026

Selecting a specific year using the FILTER function

I am trying to use the filter function to get all the records from a table for a specific year. I have a table that has a date column  The filter I am trying to use is =FILTER(Venues14,Venues14[Date...
Formulas and Functions
Olufemi7's avatar
Olufemi7
Iron Contributor
Mar 17, 2026

Hello JimCarr​, 
=FILTER(Venues14,(Venues14[Date]<>"")*(YEAR(Venues14[Date])=K5),"Is not found")

This formula filters the table to return only rows where the date’s year matches the dropdown in K5 and ignores any blank dates so it works even if some cells are empty

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 17, 2026

    If to remove (Venues14[Date]<>"") formula also works assuming we could have blank cells in Date column.