software

I'm trying to select a range of dates in an expense report. Colomn A has
dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and colomn
C and D have other data.
I can filter any kind of numbers or text, but can't find a way to do the
same for dates.
Who can help me?
Thanks.

If excel dates like 02/11/06 etc then they are just numbers and can be
filtered the same way, where lies your problem?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Sheltyquot; gt; wrote in message
news
gt; I'm trying to select a range of dates in an expense report. Colomn A has
gt; dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and
gt; colomn
gt; C and D have other data.
gt; I can filter any kind of numbers or text, but can't find a way to do the
gt; same for dates.
gt; Who can help me?
gt; Thanks.I had the date in the format quot;10-JANquot; and then it doesn't work. So I changed
the format to quot;1-10-05quot; and then it does work! Although the day is the same,
it seems that the date has to show the year to work with autofilter.
Thanks for your reply.quot;Peo Sjoblomquot; wrote:

gt; If excel dates like 02/11/06 etc then they are just numbers and can be
gt; filtered the same way, where lies your problem?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Sheltyquot; gt; wrote in message
gt; news
gt; gt; I'm trying to select a range of dates in an expense report. Colomn A has
gt; gt; dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and
gt; gt; colomn
gt; gt; C and D have other data.
gt; gt; I can filter any kind of numbers or text, but can't find a way to do the
gt; gt; same for dates.
gt; gt; Who can help me?
gt; gt; Thanks.
gt;
gt;