Thread: Filter date by month and year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_61_] Peter[_61_] is offline
external usenet poster
  
Posts: 48
Default Filter date by month and year
I have a column of dates that I am trying to filter on just the month
and year.

Date
22/05/1981
16/03/1981
26/01/2006
01/05/1986

Is it possible to filter on only the last 4 digits of a cell?

Thanks,

Peter

Reply With QuoteReply With Quote