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

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?

0 4 321
4 REPLIES 4

RezaRaoofi
Participant V

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))

@RezaRaoofi kudos as always !

RezaRaoofi
Participant V

@Suvrutt_Gurjar thanks!

@RezaRaoofi

You are the Man! Thanks dude!

Top Labels in this Space