Calculating Date Fields BY Assigned Area

Beronica Muller

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.

Paul Newcome

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))

Beronica Muller

Calculating Fields by Area.docx

Paul Newcome

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))

Beronica Muller

This worked...  Thanks!

Paul Newcome

Happy to help! 👍️