kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
With the great help of several people yesterday, I got most of what I want to work. I modified the formulas to show job on a list for 30 days or less and those jobs that have been on the list for more than 90 days.
I use =SUMPRODUCT((DATES<=TODAY()-90)*(STATUS<>"D")) for the over 90 day reference and =SUMPRODUCT((DATES>=TODAY()-30)*(STATUS<>"D"))for the 30 days or fewer formula.
Where I am getting tripped up is that period of time that is 31 days to 89 days.
Any advice?
I use =SUMPRODUCT((DATES<=TODAY()-90)*(STATUS<>"D")) for the over 90 day reference and =SUMPRODUCT((DATES>=TODAY()-30)*(STATUS<>"D"))for the 30 days or fewer formula.
Where I am getting tripped up is that period of time that is 31 days to 89 days.
Any advice?