filtering dates in order
 

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

filtering dates in order
 

Make sure the dates are actual dates, and not just text that appears to be
dates.
=istext()
=isnumber()

isnumber should return 'TRUE' if the date is an actual date.

As long as the dates are real dates, maybe you can use a helper column, and
use a function such as =day(). Reference the cells with the dates, and look
at the results. If these appear to be correct, sort by THIS column. You can
do other things after you get this all set up, such as hiding the helper
column, making the text in the helper column white so it appears 'invisible'
in the Sheet, etc.


Regards,
Ryan---

--
RyGuy


"Dawn" wrote:

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

filtering dates in order
 

I did the test and the dates came back as real.
Unfortunately, I don't know what helper rows are... I typed in the =day()
function, which returned the DAY of the month, but it still didn't filter in
order! I think I might be in way over my head on this one..
thanks again
--
dawn


"ryguy7272" wrote:

Make sure the dates are actual dates, and not just text that appears to be
dates.
=istext()
=isnumber()

isnumber should return 'TRUE' if the date is an actual date.

As long as the dates are real dates, maybe you can use a helper column, and
use a function such as =day(). Reference the cells with the dates, and look
at the results. If these appear to be correct, sort by THIS column. You can
do other things after you get this all set up, such as hiding the helper
column, making the text in the helper column white so it appears 'invisible'
in the Sheet, etc.


Regards,
Ryan---

--
RyGuy


"Dawn" wrote:

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

filtering dates in order
 

Suppose your date in column B1, put this formula in C1(=day(cell) copy this
formula at the end of your data. then sort this column i.e C1. from the
toolbar A†“Z

Your date will be sort automatically in B1

Hopefully now you will find your answer

Cherrs
Hardeep kanwar
"Dawn" wrote:

I did the test and the dates came back as real.
Unfortunately, I don't know what helper rows are... I typed in the =day()
function, which returned the DAY of the month, but it still didn't filter in
order! I think I might be in way over my head on this one..
thanks again
--
dawn


"ryguy7272" wrote:

Make sure the dates are actual dates, and not just text that appears to be
dates.
=istext()
=isnumber()

isnumber should return 'TRUE' if the date is an actual date.

As long as the dates are real dates, maybe you can use a helper column, and
use a function such as =day(). Reference the cells with the dates, and look
at the results. If these appear to be correct, sort by THIS column. You can
do other things after you get this all set up, such as hiding the helper
column, making the text in the helper column white so it appears 'invisible'
in the Sheet, etc.


Regards,
Ryan---

--
RyGuy


"Dawn" wrote:

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