Is there formula for today()!=this week (monday to sunday)

1

is there any formula to find value if today()!=Thisweek (Monday to Sunday according to my doc)

2

Hi @Korn_Tris :blush: !

Depending on your setup/use case maybe you could use WeekNumber() (which is doc dependant) or IsoWeekNumber() :blush:

E.g. :

WeekNumber
WeekNumber2078×840 80.7 KB

Or you could have a checkbox to determine if Today falls in a week and look for values where the checkbox is false :blush:

WeekNumber 2
WeekNumber 22078×870 75.7 KB

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.