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

Count the number of dates less than a given date 1
Calculate within a time range with only start date and end date 2
counting the number of dates in a date range 9
counting cells containing certain ranges of dates 1
formula to determine if multiple dates are "greater than" one date 3
Count cells with a date falling within a 30 day period. 2
how can i networkdays date ranges where dates overlap 1
Conditional Formatting in for Cells with Mixed Dates and Text 1

Top