This week filter

Hi.

I have created a slice and I want my date filter to be MON - FRI of the current week. I have tried something like [Date]>=TODAY() - WEEKDAY(TODAY()) + 1. Does not seem to be working. Am I on the right track here?

Any help would be great, thank you.

Solved Solved
0 15 925
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

Try:

AND(
  ([Date] >= (TODAY() - WEEKDAY(TODAY()) + 2)),
  ([Date] <= (TODAY() - WEEKDAY(TODAY()) + 6))
)

View solution in original post

15 REPLIES 15
Top Labels in this Space