This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Current week and Last week

Posted on 01-15-2021 02:24 AM
Marcel_Duon_Blo
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hello guys !

Can someone help me please ? I want to create two slices :

  1. A slice who show the records of current week
  2. A slice who show the records of last week

How can I do that ? Do you have an expression for that ?

Thank you.

Solved Solved
0 8 1,685
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Please try

  • A slice who show the records of current week -

WEEKNUM([Date Column])= WEEKNUM(TODAY())

  • A slice who show the records of last week -

WEEKNUM([Date Column])= WEEKNUM( (EOWEEK(TODAY()) - 7) )

AppSheetโ€™s week is from Sunday to Saturday in all WEEK expressions.

Edit: made a change in second expression

View solution in original post

Jump to Solution
8 REPLIES 8
Top Labels in this Space