filter the current year

[excelhelpseeker]

Hi Champs,


I have numerous dates in column A in mm/dd/yyyy format.


i need a macro to filter date with year 2014 only and to highlight all the other future year and last year dates.

please help me

[MarvinP]

Hi,

Have you heard about Excel AutoFilters? I think they will do what you want.
http://www.contextures.com/xlautofilter01.html

[PCI]

A conditional format with formula could help
for A3 use
=(YEAR(A3)<>2014)
See file attached