How to make a slice for yesterday, today and tomorrow data?

Hi, I was wondering if anyone could help me get a formula for my slice.

When I use this formula it works correctly: [Date] = TODAY() +1

What if I want to show not just tomorrow, but also, yesterday and today?

I tried this but it didnt work: ([Date] = TODAY() +1) and ([Date] = TODAY()) and ([Date] = TODAY() -1)

Thanks!

Solved Solved
1 2 353
1 ACCEPTED SOLUTION

GOT IT!!!
USED THIS FORMULA!

AND([Date] >= TODAY()-1, [Date] <= TODAY()+1)

View solution in original post

2 REPLIES 2

GOT IT!!!
USED THIS FORMULA!

AND([Date] >= TODAY()-1, [Date] <= TODAY()+1)

Well done!

Top Labels in this Space