Filtering for any results within a range of columns in vba

[Imabus]

Hello,

I have a macro that will open my holiday sheet and filter it to anyone who is off today and display me the results (amongst other reports that i run each morning). Currently, it just shows me who is off on that day, i would like to see a list of everyone who is off within that week.

My spreadsheet is laid out as below with names on the in column C, there are columns for each date of the month and i identify the column for today by knowing that there are 14 columns before the dates starting and adding the current date to that, then using the sum of those for the filter column. So in the below example, i would expect to see the data filtered to show only Titles, rows 6,12 and 13.

My problems are:
How can i filter on five columns at the same time to show the results where there are any results in any of them?
How am i best to identify the range i am interested in?

Hopefully, the info below will be helpful, if anyone has a thought and needs more info then don't hesitate to ask.

Thank you!

Name Mon Tue Wed Thu Fri 19th 20th 21st 22nd 23rd 1 2 3 4 5 6 HF 7 8 9 10 11 12 HF 13 HF 14 15 <tbody> </tbody>

<tbody>
</tbody>