Hi there! I need to create a filter where i ...

(Aparicio Piñeyrúa) #1

Hi there!

I need to create a filter where i can see only the data belonging to the current week and the next week.

How can I do that?

(Reza Raoofi) #2

This formula should to the job as a filter condition for all weeks including the very last week of the year:

OR(WEEKNUM([Date_Column]) = WEEKNUM(TODAY()),

WEEKNUM([Date_Column]) = IF(

WEEKNUM(TODAY()+7) < WEEKNUM(TODAY()),

1, WEEKNUM(TODAY()+7)))

If you could ignore the last week of the year in favor of simpler formula, and you could accept that only in that week your filter does not show the next week, then this formula would work too:

OR(WEEKNUM([Date_Column]) = WEEKNUM(TODAY()),

WEEKNUM([Date_Column]) = WEEKNUM(TODAY()+7))

(Suvrutt Gurjar) #3

@RezaRaoofi kudos as always ! :slight_smile:

(Reza Raoofi) #4

@Suvrutt_Gurjar thanks! :wink:

(Aparicio Piñeyrúa) #5

@RezaRaoofi

You are the Man! Thanks dude!