Hi All,
I have a spreadsheet logging trade details.
The trade dates is detailed in column G.

Is there a macro or formula I can use that will automatically delete an entire row of the spreadsheet dependant on the settement date.

ie. If the trade took place more than 5 working days ago I want to delete the entire row.

Thanks for your help