[Solved] Filter year & ignore MM DD

[RusselB]

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.

[RusselB]

Change your formula for column B to

Code: Select all   Expand viewCollapse view

=year(A1)

and reset the formatting in column B, otherwise you what you see will not look correct.
I used A1 in the formula, but adjust it for the appropriate row(s)

[FJCC]

Your column B should contain the formula

Code: Select all   Expand viewCollapse view

=YEAR(A2)

That will give you the year of the date in A2 as a number. You can then filter and sort on it.
Changing the format of a cell does not change the value, so formatting a date as YYYY does not cause functions to see only the year.

[RusselB]

Marvellous, many thanks
=year(A1)
=month(A1)
=day(A1)