I’m looking for a way to set the filter to only show the next workday.

I’m a teacher hprimary school] and each day we have a ‘topic of the day’. That topic is introduced by me the day before by a riddle. Because i would like parents at home to talk to their children about this riddle (and try to guess the topic together), I made a base with all topics, their riddles and the dates i will talk about them.

I’ve made a ‘view’ with a filter ‘where -date- is tomorrow’, but on fridays this doesn’t work as it has to show the riddle for the topic on monday (there is no topic/riddle on saturday).

I’m only using Airtable for a few months now so maybe the solution is simple…

Any help would be appreciated!!