Hi there,
I am building a report that has column rules attached, that turn tasks different colors based on due dates. My first two rules turn tasks that are due today (task planned completion date equals $$TODAY) yellow, and tasks that are overdue (task planned completion date less than $$TODAY) red. I've added a third rule, which will turn tasks due tomorrow ($$TODAY+1d) purple. This works as expected-- except it literally turns the next day's task purple, so if you look at this report on a Friday, only tasks due Saturday will turn purple. I'd like this "+1" to exclude weekends and look only at typical M-F business days, just like our project task dates do automatically. Does anyone know if this can be accomplished? Screenshot attached for reference. Thanks in advance!
