Robandemmy
Board Regular
- Joined
- Jul 16, 2018
- Messages
- 65
Hello,
I am be asking to much but is there a way to group cells based on a date? I have a row with dates (I8:ID8) from Feb 11-Dec 27. Columns B8:H8 are tasks/completion/start dates and columns I:ID are conditionally formatting to fill based on inputs to B:H.
My want is this:
For today, I want to automatically group columns I:AJ (Feb 11 - Mar 19), tomorrow I want the group to change to I:AK (Feb 11 - Mar 20), the next day I:AL (Feb 11 - Mar 21 ) and so on. I want the ability to easily show/hide the cells prior to today's date.
Any help is greatly appreciated
I am be asking to much but is there a way to group cells based on a date? I have a row with dates (I8:ID8) from Feb 11-Dec 27. Columns B8:H8 are tasks/completion/start dates and columns I:ID are conditionally formatting to fill based on inputs to B:H.
My want is this:
For today, I want to automatically group columns I:AJ (Feb 11 - Mar 19), tomorrow I want the group to change to I:AK (Feb 11 - Mar 20), the next day I:AL (Feb 11 - Mar 21 ) and so on. I want the ability to easily show/hide the cells prior to today's date.
Any help is greatly appreciated
