Forum Discussion
Solved
Need to Highlight the range of Dates (Week) where today date is fallen
Hi I have a set of dates (7 days) set termed as Week-1,2,& 3. I want to highlight the cell range where today date has fallen. Can you please help WEEK 1 WEEK 2 WEEK 3 18-Dec-21 24-D...
With conditional formatting
=((B2<$A2)*(C2>$A2)*(MOD(COLUMN(B2),2)=0))+((B2>$A2)*(A2<$A2)*(MOD(COLUMN(B2),2)=1))
Before that, highlight B2:G7 and then Formula in Conditional formatting and select color.
...maybe it will help 🙂
Please See below table, today date 13-05-2022, which is fallen between 10-05-2022 to 16-05-2022 range in week 2 (Circled).
What I need is a conditional formatting (Green), whenever the date fallen between range of dates. (Weeks).
here is a suggested solution with SUMPRODUCT...I think it fits better :)).
=SUMPRODUCT(($B2:$G2<$A2)*($C2:$H2>$A2)*(MOD(COLUMN($B2:$G2),2)=0))