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

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.
--
David Biddulph

"Dawn" wrote in message
...
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.
--
dawn

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 39569
=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

--
dawn


"David Biddulph" wrote:

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.
--
David Biddulph

"Dawn" wrote in message
...
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.
--
dawn

I'm sorry, I want to sort and or Filter by the FIRST COLUMN.
thanks for your help
--
dawn


"David Biddulph" wrote:

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.
--
David Biddulph

"Dawn" wrote in message
...
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.
--
dawn

The first column looks as if it is producing either empty strings or
numbers, and the numbers should therefore sort. [Dates are merely numbers.]
--
David Biddulph

"Dawn" wrote in message
...
I'm sorry, I want to sort and or Filter by the FIRST COLUMN.
thanks for your help
--
dawn


"David Biddulph" wrote:

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.
--
David Biddulph

"Dawn" wrote in message
...
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.
--
dawn