How to count number of rows where a date in a column is equal to a specific date?

svijay22

Hi all,

I am trying to create a time series line chart to show the progress of issues put in a specific status every day. On our Issue log, we have date column which captures the date on which an issue was set to either Rejected, Closed or Acceptable Difference. Created a supporting sheet to map the data for the chart below. For Ex: I am trying to get the total number of issues put in Rejected status on 16th Oct. But its currently returning 0. Can someone please help with am I doing wrong in the formula?

Formula in these cells - =COUNTIFS({MSI Model Office Testing Log - Status}, Rejected1, {MSI Model Office Testing Log Range 2}, $[Issue Close Date]@row)

Note - both the date columns are of type Date

svijay22

Hi @Paul Newcome - yes, please see below. Anything else I might be doing wrong?

Column which captures the date when any of the rows are put in any of the three statuses above -

Column where I have daily dates to map the data for the time series line chart -

Paul Newcome

Have you ensured that both date columns are in fact set as date type columns and have date type data in them?

svijay22

Hi @Paul Newcome - yes, please see below. Anything else I might be doing wrong?

Column which captures the date when any of the rows are put in any of the three statuses above -

Column where I have daily dates to map the data for the time series line chart -

svijay22

@Paul Newcome - apologies, its now working. I just had a minor user error. Thanks for your time.

Paul Newcome

Happy to help. 👍️

LesahDee

I am cross referencing 2 different sheets getting an error can someone help.

=COUNTIF({Munis Range 1}, "Facilities", {Contract Extensions Range 1}, NOT("Expired", "Closed"))

I want it to count if the first range is "Facilities" and if the second range is NOT "expired" or "Closed"