Dynamic filter based on day name

Dynamic filter based on day name

I have a list of account we deliver to each day of the week. Different accounts are serviced on different days. I need to email our staff daily a list of the accounts serviced that day. I've added a calculated field named CurrDay with this expression:

weekday( currentdate( ))

Then I tried to create a filter in the DeliveryDay field where its value In CurrDay, (or In [CurrDay], or In =CurrDay, or In =[CurrDay]), none of which worked. Then I tried putting the calculation in the filter itself (In weekday( currentdate( )). This, too, failed. 

All I want to do is say, "If today is Monday, show the Monday deliveries." Is there a way to do that?

Thanks

Keith