Help: Creating Drop-Down Menu to Filter Table by Year

[spartrocl]

I currently have a task managing spreadsheet that is organized by approaching deadline (upcoming deadlines appear first on the list in order of when they are due).

I want to create a dropdown menu at the top of the spreadsheet with options "2015, 2014, 2013, etc" so that I can easily see deadlines from past years. Additionally it would be helpful to be able to have another dropdown menu for the month "April, May, June, July, etc" so that it could be even more specific.

Does anyone know how to do this? I know I have seen this done on accounting spreadsheets, but I can't figure it out.

 

[QU4487]

Without seeing your worksheet I'm going for the easy option. You could add a column which cuts out the year from the dates column. If Column A = Date, then =YEAR(A2).

Then simply add a filter on this column.

If this isn't what you're looking for, you may wish to post an example of the worksheet to help visualise what you're after.

Q

 

[spartrocl]

Without seeing your worksheet I'm going for the easy option. You could add a column which cuts out the year from the dates column. If Column A = Date, then =YEAR(A2).

Then simply add a filter on this column.

If this isn't what you're looking for, you may wish to post an example of the worksheet to help visualise what you're after.

Q

Thanks so much for your response! Bellow is a screenshot of my spreadsheet. Basically I want things to move to another worksheet when the date has passed, and I also want to be able to add a filter by date for future reference, so that next year at this time, I could select "2015" and "April" to see what I was applying for the year before.