Hello,
I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month long task that neither starts nor ends in a 3-week period, it will not meet those criteria, however the task will occur during that time.
The WEEKNUMBER function has similar constraints.
Is there any way around this?
