+ Reply to Thread
Results 1 to 3 of 3

filter dates in data range

  1. #1
    Shelty
    Guest

    filter dates in data range

    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.

  2. #2
    Peo Sjoblom
    Guest

    Re: filter dates in data range

    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




    "Shelty" <[email protected]> wrote in message
    news:[email protected]...
    > 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.



  3. #3
    Shelty
    Guest

    Re: filter dates in data range

    I had the date in the format "10-JAN" and then it doesn't work. So I changed
    the format to "1-10-05" 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.


    "Peo Sjoblom" wrote:

    > 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
    >
    >
    >
    >
    > "Shelty" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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.

    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1