Date filter for specific dates

excelhelpseeker

New member
Joined
Jan 7, 2015
Messages
29
Reaction score
0
Points
0
Hi champs,

Please provide me a macro or function to capture date filter for the below requirement.

1. i need dates between jan 1 3014 and today's date. all View attachment sample.xlsxothers should be highlighted in any color. Thanks in advance.
 
Just use cxonditional formatting with a formula of

=OR(A5<--"2014-01-01",A5>TODAY())
 
Back
Top