date filter

  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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....
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...

Some videos you may like

This Week's Hot Topics