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?