Itβs now a whole lot easier thanks to concatenation in formulas
If( (ToDays(Today() - [Creation Date]) > 30) and (State.Final = false) ),ββ,ββ) + if ( (ToDays([Due date] - Today()) > 0) and (ToDays([Due date] - Today()) < 7) ),β
β,ββ)