Day to day number of not answered requests

  • Thread starter Thread starter n61
  • Start date Start date
N

n61

Hi, I'm having a following table :
A request id
B request detail
C request date
D answer date

Is there a way, with a pivot table, to get the following table :
A date
B number of not answered requests

??
 
How about:

=COUNTIF(D2:D65536,"")-COUNTIF(C2:C65536,"")
This will give an incorrect answer if there are any answer dates without
request dates.
 
Back
Top