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
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