Slice not working

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.

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

1 Like

Can you give a screenshot from your sheet?

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

WEEKNUM(TODAY()) - 1

gives you Zero (0). However,

WEEKNUM([Day])

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

1 Like

Is there a workaround??

Use instead:

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

Thank you @Steve and @LeventK

2 Likes

You’re very welcome.