Using Autofilter to Sort Date Range?

[smlaff01]

Hi, I am working with a table of data which I am sorting with auto-filter. Currently I am interested in entries which will occur in February 2008. I have a column of data with the date value which is formatted to read as: 2/4/2008. Is there a way to look at a range of dates (say from 2/1/2008 - 2/28/2008)? Right now I am having to go through and look at the entries on a date by date basis, so the ability to select a data range would be very helpful.

Thanks for any insight.

[arthurbr]

Hi,
for starters don't forget february 2008 has 29 days

You can use autofilter to view an entire month.
Choose "Custom" from the drop-down box in the first cell of the date column
In the first box choose "greater than" and fill in the begin date
Check " and"
In the 2nd box choose "smaller than" and fill in the end date in the last box
OK
This should do the trick

[smlaff01]

That's right this is a leap year isn't it!

I had tried using your prescribed method previously, but I am not having any luck. I thought that maybe it wasn't recognizing the date? I have the cells formatted as "date". Is there away to convert the date into a standard number? or would this even help?

[smlaff01]

I'm still trying this and have noticed that I can convert the date to a serial number in a test excel session, but I am working with a BW Query and have not been able to convert the date to serial number within this?

[Paul]

Hi smlaff,

Regarding your statement:

I have a column of data with the date value which is formatted to read as: 2/4/2008.

It's formatted to read m/d/yyyy, but what is the original format? If it's not a standard date format that Excel would recognize (or the serial number date itself), then searching for a range > and < two dates won't work (as you've found out).

[smlaff01]

By way of using '=Isnumber()' I have determined that the dates being pulled in are text, not numbers. Is there a way to convert, or am I stuck?

[Paul]

If your dates are in column A, in another column you can put the formula:

=DATEVALUE(A1)

and fill that down as many rows as needed. You should then be able to filter on the calculated column.

[VBA Noob]

smlaff01,

Please read forum rules and message to cross posters below and then add the link to the other forum

VBA Noob