how do I look for cells showing dates less than a certain date?

  • Thread starter Thread starter Annie and Naseem @ Ecojustice
  • Start date Start date
A

Annie and Naseem @ Ecojustice

I've constructed a table with dates of employee departures and need to
"sort?" all of those who left over 7 years from the current date. This has to
be done on a repeated basis. How do I set this up and do it?
 
Annie/Naseem,

Use a formula like

=A2<DATE(YEAR(NOW())-7,MONTH(NOW()),DAY(NOW()))

Where A2 has your date. Then copy down, and filter that column to show only
TRUE values.

HTH,
Bernie
MS Excel MVP


"Annie and Naseem @ Ecojustice" <Annie and Naseem @
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top