+ Reply to Thread
Results 1 to 10 of 10

Date filter for specific dates

  1. #1
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Thumbs up Date filter for specific dates

    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 others should be highlighted in any color. Thanks in advance.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,319

    Re: Date filter for specific dates

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: Date filter for specific dates

    Hi,

    Find attached sample.sample.xlsx

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,319

    Re: Date filter for specific dates


  5. #5
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,319

    Re: Date filter for specific dates


  6. #6
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: Date filter for specific dates

    Yes. i can by conditional formatting... whether can i get this done by help of a macro????

  7. #7
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,319

    Re: Date filter for specific dates

    Sure:

    Try this:

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: Date filter for specific dates

    thanks. it doesnot capture the future dates.
    if i need to color the tomorrow date and the future dates????... pls help

  9. #9
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,319

    Re: Date filter for specific dates

    This code will color only dates greater than today.

    Option Explicit

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: Date filter for specific dates

    thanks for the help. it works fine................

+ 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. [SOLVED] VBA code to filter on Specific two dates ( pivot table)
    By tejal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-24-2014, 03:36 PM
  2. [SOLVED] Filter dates according to current date
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 04:57 PM
  3. Custom date filter for next twelve months from a specific date
    By andymcnichol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 07:24 PM
  4. [SOLVED] Date Filter based on Cell Input - single date or range of dates
    By babaloo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2012, 10:32 AM
  5. Problem with Date Filter between two dates
    By bhaskar_bkp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2010, 01:20 PM

Tags for this Thread

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