date filter

  1. S

    VBA filter by date + 2 days in the future

    I am trying to create a button that will filter a table and delete row entries that are more than two days a head (i.e. today is Monday and I want to delete rows that have a date past the coming Wednesday). The date column is in column A and I have D2 is "=Today()" I am getting the "Run-Time...
  2. T

    Excel date vba filter

    Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...
    • Tommy5
    • Thread
    • date date filter filter format formatting vba vba date
    • Replies: 4
    • Forum: Excel Questions
  3. P

    Pivot Tables - Date-slicer that is NOT timeline-layout

    Hi, I wonder if there is a way to filter/slice a pivot table in the exact same way that a timeline-slicer works, but with manually entering dates instead of marking them on the timeline. I want it to function as a slicer in a dashboard-worksheet. Like the "Date Filter -> Between" but as a...
    • Papale
    • Thread
    • date filter filter pivot tables slicer timeline
    • Replies: 0
    • Forum: Power BI
  4. G

    Autofilter using two date interval_dates stored in two columns

    Dear All, I have a database of projects and I need to filter to those projects which were active in 2016. Column J contains the projects' start date, column K contains the projects' end date in a mm/dd/yyyy format. So I do not want my filtered list to contain projects that run out of this...
    • gyorid
    • Thread
    • autofilter date date filter projects two columns
    • Replies: 2
    • Forum: Excel Questions
  5. H

    Exel Schedule Filter Issue

    Hi, I have a production schedule and I am trying to filter the schedule based on the completion date but when I hit filter to choose a specific date, I am only seeing the 1st production date of December 1st and not all of the the production dates for the month of December. What could be wrong...
  6. J

    VB Code for date filtering

    Hi, I wanted to filter column C with a condition that the date in C is greater than a date availabale in cell N1 Can anyone help me with the VB code for this Thanks and Regards
  7. J

    Pivot Table Filter

    Does anyone know of a way I can make my pivot table filter select the day where "X" field was highest? I only want the date with the highest "X" to be selected....
  8. T

    Controling Date Filter on Pivot Table with drop down

    Hopefully someone can help me! I have a table with business data such as units sold, revenue etc. entered by date (1/1/14, 1/2/14...) for 4 different business units. I have this data summarized in a pivot table. The pivot table is set up with the date filter as a row label. I would like to...
  9. M

    Excel 2013: Filter Date using Timeline filter

    Hi all, I just got into the world of PowerPivot, Excel 2013 and Pivot Tables and am in the process of creating a Dashboard which I will then be uploading to SharePoint 2013. On top of page I added the new timeline filter which I've linked to my pivot charts. Now what I would like to do, is...
  10. A

    how do i define the oldest 2 dates in vba

    Hi everyone, I am new to Excel programming and I have a question regarding finding the oldest 2 dates in a specific cell. I am trying to build an application that automatically sends an email but can't seem to filter the 2 oldest dates which is why when I click on send, all the records are...
    • ayansen
    • Thread
    • date and range date and time stamp date aritmetic date filter date filter problem
    • Replies: 3
    • Forum: Excel Questions
  11. J

    Excel 2007 Pivot Table Help - 3 hours lost .... please help!!

    Hello, I need an advanced user on Excel 2007 pivot tables [or at least someone better than me....] <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a workbook with multiple worksheets. One worksheet has my source data and the other worksheets have...
  12. X

    How to filter based on date?

    Hi newbie here, I don't have any macro knowledge but I am trying to create a macro that filters transaction records based on their aging days. I need to filter transaction older than 2 months, 3 months, and so on. I don't know if it is possible to put the aging calculation on macro but I tried...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top