date filter problem

  1. E

    date filter

    I have a worksheet with dates of the year listed (Mon 11/02/2019; Tue 12/02/2019 etc) from beginning of the year to the end. This column is set as dates format so that they autocalulate when a date is put in the first cell of the column and a filter on the column. Is there any way I can filter a...
    • estelle
    • Thread
    • column date date filter problem filter dates year
    • Replies: 2
    • Forum: Excel Questions
  2. M

    Filtering date field

    Can anyone help? I have problem with date filetr. My general idea is to let the team to put their input, chose the input type, their action and the code do the rest. So far, displaying the items. My problem is by Date field entries. It shows nothing. I checked tha site and found I should use...
  3. H

    Change date in a OLAP Cube based pivot table

    I have had posted a similar issue earlier, but it did not solve my problem. Therefore, I try again. My Pivot table gets data from a OLAP Cube. Using the macrorecorder i got this code by setting a new date in the filter and then update the Pivot table. I can manually change the date and it will...
    • Hans10
    • Thread
    • date filter problem format cells in vba olap pivot filter reference 2 cells update pivottable
    • Replies: 1
    • Forum: Excel Questions
  4. H

    Another how to change pivot filter in a OLAP cube based on a cell value

    Hi! yes I know it - there are a lot of questions about this tast on the internet and also here om Mr Excel. but still, i cant get right! - Please help me :confused: I have several pivot tables based on a OLAP Cube (the same cube). What i want is to update to a specific Date (from a Cell) in...
    • Hans10
    • Thread
    • date filter problem date value olap pivot filter pivot filter vba pivot table
    • Replies: 4
    • Forum: Excel Questions
  5. 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
  6. J

    Pivot table date filter disappears when data changed

    Hi, Working in excel 2007. I have set up a pivot table to view sales figures. I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted. When I built the pivot table from scratch, when I chose to...

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
Back
Top