Skip the weekend

796 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!!

1 Reply 1

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