Skip the weekend

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

I’m a teacher [primary 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!!

You could create a formula field with WORKDAY_DIFF() and TODAY() and your date field. Then filter on the result.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.