I am looking to filter a data table and its output results which include COUNTIFS functions using excels date filters option.
How can I modify the cells in C27:K42 (HIGHLIGHTED YELLOW) on 'Table' Sheet so that the data changes when i apply a date filter on column B in the 'Metocean Data' sheet for say months may/jun/jul/aug? or indeed a single month so that all dates for these specific month(s) are only included in the countifs fuction calc.
The workbook already allows for filtering based on a specified start and end date but looking to modify so includes just specified month(s) for all the years of data. Ideally I would like to be able to just apply the date filter on the data sheet and the table for occurences update automatically
Also, is there a way to select more than one month when use date filters>all dates in the period>may+june+jul+aug etc as seems to only allow single month selection?