Hello,

I am attempting to define an issue priority based on the assigned due date. Below is the IF Statement that I am using. It works fine for the "Critical" (<=+5) and "Low" (>+30) as these do not include ranges. I am having issues on the "High " and "Medium" values. They will work fine if the due date is exactly 15 days from Today (High) and 30 days (Medium) My question is how do I write the formula so that it returns the "High" value for all dates that are >5 and <= to 15 days as well as a Medium value for all days that are >15 and<30 days from due date?

=IF(I15=TODAY()+5,"Critical",IF(I15=TODAY()+15,"High",IF(I15=TODAY()+30,"Medium",IF(I15>TODAY() +30,"Low"))))

Finally, once I get this working, I want to have a formula that will provide a total count based on current priority.

Any help or guidance would be greatly appreciated.

Thank you