Slice not working

[Mauricio_Bick]

I’ve been using the following formula but suddenly the slice doesn’t return anything…

WEEKNUM([Day])=WEEKNUM(TODAY())-1

My template has no records because of this.

Any ideas??

Thank you.

[Steve]

I would guess there are no values of the Day column that occur last week.

[LeventK]

Can you give a screenshot from your sheet?

[Mauricio_Bick]

[Mauricio_Bick]

My spreadsheet has data for last week. Screen shot below.

[LeventK]

WEEKNUM(TODAY()) - 1

gives you Zero (0). However,

WEEKNUM([Day])

is 53. That’s why you can’t see any records.

[Mauricio_Bick]

Is there a workaround??

[Steve]

Use instead:

(EOWEEK([Day]) = (EOWEEK(TODAY()) - 7))

[Mauricio_Bick]

Steve:

(EOWEEK([Day]) = (EOWEEK(TODAY()) - 7))

Thank you @Steve and @LeventK

[LeventK]

You’re very welcome.