Calculating Date Fields BY Assigned Area



It's me again. I am attempting calculate the number of days between referenced columns. For example, I would like to know the how many inquiries that an assigned group has for x amount of days. I have grouped the pending days by 0-7 days, 8-15 days, 16-23 days, 24-30 days. I used the formula =COUNTIFS({National Alliance Operation Inquiries Range 1}, "NAOPS.Priority" > TODAY (-7)) and received the following error #UNPARSEABLE


I have provide screenshots for review.

Best Answer