How to filter by days of the week

Hello everyone, 

Pretty new to the Fusion scene so apologise if this has been answered somewhere else/for the silly question.

I am having the following scenario and I am having some troubles with setting the filter up:

there's an excel that I am having and that I am creating requests based on it, and I would like to set some filters up so that not all requests within the excel are created on the same day, therefore I have introduced a column (days of the week) so that I can filter by it. Now here comes my issue: I am unsure how to filter by "today". In workfront we had the $$TODAY variable that we could use, I see in Fusion there's the "now" variable, but I cant seem to make it work, I ve tried pretty much all the operators and conditions and I am out of ideas. I could make like 5 scenarios for each day of the week but I believe there should be another way of doing it within the same scenario.

TLTR: I'd like to filter by a column (value) that has the days of the week in it and would like the day of the week to be compared to "now" or "$$TODAY" (what day currently is - e.g. Monday). 

Thank you for your time and suggestions!