Group Cells

Robandemmy

Board Regular
Joined
Jul 16, 2018
Messages
61
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,109,042
Messages
5,526,420
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top