filtering dates

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

Please help me. I have created a schedule that I would like to filter by
date. Is there a way to filter the dates in order? I can filter by the
month, date or week... for example if I filter by the month of May, all of my
May dates are returned, however, they are not in order...

I've tried to do a sort, but I believe because I've used formulas for the
date, that won't work.
 
If they are real dates, rather than text, then they will sort correctly.

If you are having problems, tell us more detail of what you are trying to do
and what problems you are encountering.
 
I'm pretty sure they are not real dates. I know just enough about excel to
get myself in trouble. I had a friend help me with the formula's.. they work
great UNTIL I want to sort or filter them.. Following is what I have thus
far. my goal is to filter or sort the last column by date.

(I copied and pasted the information, I hope you can figure it out) There
are 5 columns and 7 rows per group..

=IF(M2="","",IF(M2=0,"",N2+J21)) =1 INSERT NAME 39539 3956
=IF(M3="","",IF(M3=0,"",N3+7)) =L2+1 =IF(M2="","",M2) =IF(N2="","",N2) =IF(O2="","",O2)
=IF(M4="","",IF(M4=0,"",O4-58)) =L3+1 =M3 =N3 =O3
=IF(M5="","",IF(M5=0,"",O5-28)) =L4+1 =M4 =N4 =O4
=IF(M6="","",IF(M6=0,"",O6-14)) =L5+1 =M5 =N5 =O5
=IF(M7="","",IF(M7=0,"",O7-2)) =L6+1 =M6 =N6 =O6
=IF(M8="","",IF(M8=0,"",O8+1)) =L7+1 =M7 =N7 =O7
 
The first column looks as if it is producing either empty strings or
numbers, and the numbers should therefore sort. [Dates are merely numbers.]
 
Back
Top