In an excel sheet I have column where there dates in the format as below :
I want to use select query (excel as database) where I want to filter records using the year only. Basically, I want to build a query something like this : select * from [Sheet1$$] where ‘Date’ <> 2021.
In the above query what I am trying to do is filter the records where year is 2021 and leave rest of the records.
Need some help on how to achieve this. Thanks in advance :)