Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Filter for >=Today() (Excel 2000>)

    Hi,

    How can I filter a list containing a range of dates, and extract all dates that are >=Today().

    I tried to use the TODAY() function as a filter, and it does not work! Is this possible as I would like a dynamic filter that extracts data from the current date and future when I refresh the data list!

    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter for >=Today() (Excel 2000>)

    Are you using Advanced Filter? If so, set the criteria to

    =">="&TODAY()

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for >=Today() (Excel 2000>)

    Yes...I'm using Adv. Filter
    Tx...It works, Stunning!
    Regards,
    Rudi

Posting Permissions

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