Custom date filter for next twelve months from a specific date

Hi,

Got a meeting on monday at work and need to find out how to set up the company job list excel file to show the current workload for the next twelve months from the current date.

Can anyone help?

I've attached the file in question with some of the sensitive data removed.

The main fully functioning workbook has a few buttons that are shown on the top of the attached workbook which run some of the date filters in the filter options. One really important one for my meetings would be for the workbook to, at the click of one of the macro buttons, show the workload for the year ahead based on the date in the input box at the top right of the table.

I know there is a next year filter but that starts from Jan every year doesn't it?

Can anyone help me with this?

Thank you

Andrew

hi Andrew, code to be assigned to a new button for workload 1 year ahead:

Please Login or Register  to view this content.

Thank you very very much!

Brilliant help!

Regards

Andrew