Date help

[PrinceExcel]

Hello. I am copying dates to another sheet then after pasting it shows long date but when trying to filter it it still shows long dates. I can't filter it with years..but I cant find it even changing format to dates. Please help.

 

[Joe4]

I don't think your question is clear.
What is it exactly that you are trying to do?
What filter do you want to apply?