Macro that deletes rows that are blank in a column H and last Fridays thru Current Date

I'm slowly trying to automate a weekly report that I put together every Monday (sometimes Tuesday). The example I attached is from Monday 7/3 and hope to be able to use this macro on 7/10 or 7/11.

I need a macro that will delete the row if the text in Column H is blank AND the date in column C is the previous Friday thru Current date (6/30,7/1,7/3,7/4) .

In this example, 3 rows should end up being deleted. This data is usually 15,000 ish rows long and the dates update every week but the criteria stays the same.

Thank you so much in advance

I am getting a run time error 1004: " This can not be applied to the selected range. Select a single cell in a range and try again."
Debugger highlighted line 23- .AutoFilter field:=8, Criteria1:=""

I don't have any lines that would be deleted this week anyways with these macro but I would to get this figured out so i can call on it in another macro