Thread: filtering dates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default filtering dates

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