Forum Discussion
Highlighting a row based on the day of the week
Hello everyone!
This is my first post in this forum and I just have a quick question.
Currently I have an excel document set up to highlight the next day's jobs by using "=$I9=TODAY()+1". However, when Friday comes around I would like to highlight Monday instead of not having anything highlighted. I tried messing around using the IF and Weekday functions, but I couldn't get it to work. I was using the IF/Weekday Functions in order to try and subtract days from the total (Friday - 4 = Monday etc)
Any suggestions would be very much appreciated.
Thank you,
Christopher_P
When it could be
=INDEX($I:$I,MATCH(TODAY()+CHOOSE(WEEKDAY(TODAY(),2),1,1,1,1,3,2,1),$I:$I,0))=$I1
See Sheet2 attached where A1 is instead of TODAY()
7 Replies
Sergei,
I attempted to insert that into the sheet that I was using, and it only registered one out of six jobs that it should of highlighted, as well as a few rows that don't even have a date on them!
I imitated it on this model
where A1 is instead of TODAY() - it works. How your data is structured?
