I need help with a macro, I have dates in column F or column number would be 6 and I need to filter this column based on Todays date and 1 week prior so for example... Today is 5/28/15 so I need the macro to say ok we need to only keep the rows with 5/21/15 through 5/28/15 the rest we need to delete...
How can I go about doing this?
It has to be something with using
oneweekdate = date - 7
filter oneweekdate to date and delete everything else??? someone please help me
How can I go about doing this?
It has to be something with using
oneweekdate = date - 7
filter oneweekdate to date and delete everything else??? someone please help me
