Checking if a certain day falls in a range
Dear Excellent users.
I have a day [=TODAY()] in field AK1
In A1 I have the number of the week.
In fields A2 till E2 I have the five days of the week noted in MM-DD
Now I want to use conditional format for the number of the week. I want to
check if the day of AK1 falls in the range of A2 till E2. If such is the
case, I want the number of the week highlighted.
Can someone help me??
Thank you !!
--
** Fool on the hill **
|