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! Go to Solution.
Try:
AND(
([Date] >= (TODAY() - WEEKDAY(TODAY()) + 2)),
([Date] <= (TODAY() - WEEKDAY(TODAY()) + 6))
)
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |