+ Reply to Thread
Results 1 to 12 of 12

filter the date with filter automatic

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    filter the date with filter automatic

    Hello to all.
    Until Excel 2003 can filter out the dates with the option:

    greater than or equal / less than or equal in the custom filter.

    In Excel 2007 I do not see these two options.
    I have to filter for example all the 2012 dates in a range with many more years.
    A help?
    max_max

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic

    Filter data in a range or table

    Filtrare i dati in un intervallo o in una tabella
    Last edited by sandy666; 03-24-2017 at 03:13 PM.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: filter the date with filter automatic

    Thanks sandy666 but I not see this automatic filter option:

    is greater than o equal to
    is less than o equal to

    In Italian is

    è maggiore o uguale a
    è inferiore o uguale a

    max_max
    Attached Images Attached Images

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic


  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: filter the date with filter automatic

    Not number but dates (years)
    max_max

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic

    date is a number, year is a number, month is a number, day is a number
    first try

    or Ex2007 date filter
    Last edited by sandy666; 03-24-2017 at 03:25 PM.

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: filter the date with filter automatic

    number is format cell = number or text
    date (years) is format cells = date (gg-mm-aaaa) (dd-mm-yyyy)
    max_max

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic

    ????
    date is a number
    select cell with your any date, go to ribbon, change format to a number, you should see 42818 (24/03/2017). If not, your date is a text string
    Last edited by sandy666; 03-24-2017 at 04:06 PM.

  9. #9
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: filter the date with filter automatic

    I made a big mess with the choices in custom filter.
    I was used with Excel 2003 and Excel 2007 is very different.
    I found the exact choice of Excel 2007:
    In inglish is :

    It is after or equal to
    It is before or equal to
    max_max
    Attached Images Attached Images

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic


  11. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic

    But nevermind if it works

  12. #12
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: filter the date with filter automatic

    If the basic problem is solved
    - it's always a good practice to show respect to the person(s) who have helped you
    - is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
    - mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Filter not allowing filter by year, month and date
    By Steve aka Munky in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-17-2017, 11:47 AM
  2. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  3. Pivot Table: OR condition filter on Multi Date/Sum Filter
    By ddalt10 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-09-2013, 12:49 PM
  4. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  5. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM
  6. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM
  7. Extract filter items from Drop-Down Automatic Filter
    By karpatov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2006, 02:10 PM

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