Im having an issue with the drop down filter in excel. Currently as it stands I have an excel sheet with a few columns that won't be changed add order columns that are sorted by date.
I am currently wondering the best way to fill to the date columns in the excel sheet.
Currently I've worked on doing a drop down to select the period of what I want to figure out as well as a table which currently says the dates in this month.
The first picture is what I currently have at the moment at the second picture is what I hope to achieve which is that when I select the period of this month which is on the top of the page it then only selects the current month of work.
I've tried numerous formulas for this and I'm currently getting errors and sometimes just blank.
I'm not used to excel so if anyone has an idea of what formulas I could use I was currently following a YouTube video (https://www.youtube.com/watch?v=hj6JSSQIrdw&t=1204s) [[Currently what I have at the moment](https://i.stack.imgur.com/dgq3r.png)](https://i.stack.imgur.com/NTneh.png)
I tried different formulas and I hope that under the date column when i select this month in the select period drop down then i can have it filtered to the current date.
Ive tried putting the dates in a different sheet but that's not working either