3 Replies Latest reply on Dec 12, 2017 4:42 AM by brandon.lum

    Create Month/Day Filter for multiple years on one sheet

    brandon.lum

      I have a set of data that needs to be able to filter for specific Date (Month/Day) across multiple years.

       

      Example:

       

      Right now, for what I can see, we are only able to set an "Ending Date" to MM/DD/YYYY". I'm solving this problem by creating each sets of data for each respective dates in their own worksheets and then bringing them together in a dashboard. Though this works, unfortunately, I'm unable to now do table calculations across multiple years.

       

      Is there a way to change it to MM/DD or create some kind of filter to do this?