Delete Rows Which Have Date 7 Days Old

Hi,

Assuming all your dates are in column A put a column label like 'Date' in A1 with your dates starting in A2, in B2 enter

=TODAY()-A2

and copy this down column B against all your dates.

Now put your cursor in A1 and from the Menu choose Data>Filter>AutoFilter
Click the drop down arrow in B1 and select 'Custom' and choose 'is greater than' and in the other drop down enter '7'

Now select all the filtered rows and delete them.

HTH