Filter year & ignore MM DD
Col A: Date with format YYYY-MM-DD
Col B: Date with format YYYY
formula in B: =A_ _is equal row number
Set Data range and autofilter.
Click filter arrow above first date in column B:
Full date is shown. Selecting just the year is impossible.
I need to filter select the year, independent of MM DD and sort order.
May be the YYYY could be extracted and converted to text?
The column B should remain useful for filter and sorting.
Guidance? Thanks.