I am preparing a dashboard whereby I can view my records based on week. It seems like there is no formula that allows me to match by Week. Similar to Excel we can filter by This Week, Next Week.. etc.
So will be good to have these formula added.
You could use the DateDiff function to see how many days away from Now your date is, and if less than 7 then it is this week, if 7-14 then next week, etc.
Thanks! Thats great!