Hey guys,
I'm stuck trying to use the formula "IF" or "SEARCH"; as shown in the picture, every server belongs to a particular week. I'm looking for the formula that shows me which server is supposed to work today. Therefore, I want excel itself to tell me who the server is designated for this week since the date is updated with the formula =TODAY(). For example, according to the picture, the server would be "Kristin".
If anyone knows how to solve this issue, I would highly appreciate it,
Santiago
