Question

I currently use formatDate(prop("Due Date"), "dddd") to return the day a task is due in a Day property.
I then group tasks by that formatted Day property in a board view so I can easily get an overview of my week.

Is there a way to return multiple days within a date range so that, say, if I have a task I need to work on Monday, Tuesday, and Wednesday, the formula will format the days within a range of time in the Day property so the task will appear under all of those days in my board grouping?

Answer 1

You do not need to name all days, just mark the current week as true with a Notion formula.

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Now you can just filter where this week is true and done.