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

  • Thread starter Annie and Naseem @ Ecojustice
  • 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?
 
B

Bernie Deitrick

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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional Formatting Dates Less Than 14 Years Ago 2
Excel 2010 countifs for date range 3
Allocate an income payment over a date range (tax years) 7
Conditional Format based on date 2
Calculate within a time range with only start date and end date 2
Working on birthday "book" for my wife and having layout/editing trouble 0
Weekending Date w/Less Than 3 days Assoc. with Prior Month 7

Top