Sorting/Function Help

  • Thread starter Thread starter saboolla
  • Start date Start date
S

saboolla

I need help on excel.
I need to find a easy way to sort.
I'm trying to find out how to take out dates that are more than 10, 15
20, and so on days.
Say you have a list of dates:
How do I pull out the dates that are 10 days or 30 days past?
I tried using sort but that don't help.
I tried using If and Countif functions. I don't get how it works. I'
stuck.
Please help. Thank You.

1-Jun
2-Jun
3-Jun
4-Jun
5-Jun
6-Jun
7-Jun
8-Jun
9-Jun
10-Jun
11-Jun
12-Jun
13-Jun
14-Jun
 
You could add another column with a formula like:

=today()-a2
Format it as General
and drag down the column

Then apply data|filter|autofilter to that column and show the dates that are old
enough (greater than 10, greater than 30, ....
 
Back
Top