Results 1 to 2 of 2

Thread: Date filter for specific dates

  1. #1

    Date filter for specific dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi champs,

    Please provide me a macro or function to capture date filter for the below requirement.

    1. i need dates between jan 1 3014 and today's date. all sample.xlsxothers should be highlighted in any color. Thanks in advance.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,823
    Articles
    0
    Excel Version
    O365
    Just use cxonditional formatting with a formula of

    =OR(A5<--"2014-01-01",A5>TODAY())

Tags for this Thread

Posting Permissions

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