Calculating Date Fields BY Assigned Area
Hello,
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
-
You are going to want your formula to look something along the lines of this...
=COUNTIFS({Source Sheet Responsible Area Column}, "NAOPS.Priority", {Source Sheet Date Column}, @cell > TODAY(-7))
Answers
-
You are going to want your formula to look something along the lines of this...
=COUNTIFS({Source Sheet Responsible Area Column}, "NAOPS.Priority", {Source Sheet Date Column}, @cell > TODAY(-7))
-
This worked... Thanks!
-
