Help needed with formula calculating open issues based on status, owner and due date

melisaozdeniz

The formula is not pulling all data. Below are the formulas I am using:

Overdue: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <TODAY(0))

Due in 1 month: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(30), {Current Completion Date}, >=TODAY(0))

Due in 3 months: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(90), {Current Completion Date}, >TODAY(30))

Paul Newcome

Is it missing counts that should be included? Have you tried applying a filter to the sheet that mimics the range/criteria sets to see how many rows should be getting pulled in?