Excel EXCEL - using a date dependant formula to hide rows

[edhewitt]

Hi,
I use a multi sheet spreadsheet at work to track outstanding tasks.

I would like to write a formula to take today's date and hide the row if it is:
1- less than a week since the last entry
or;
2- hide the row if it from the current month.

I would also like to write a formula that hides the row or column if all cells in use in that row or column have been checked.

Thank you in advance for your assistance.
Ed

 

[Becky]

Is it necessary to hide the row? The only way you might be able to do that is with a macro, but I think it would be complicated and messy. A more simple way would be to use conditional formatting - for example you could make the text a light grey (or even white) if the conditions are met. It wouldn't hide the row, but it would mean the other rows stand out by comparison.

 

[edhewitt]

No, the rows or columns need to be hidden, the sheets are used to track outstanding tasks by guys in the field so need to be able to be referenced quickly, and either weekly or monthly the task is due again.
There are up to 200 rows and about 20 or 30 columns on some of the sheets.

 

[edhewitt]

I can hide manually but it is time consuming and introduces human error.