I need help creating a Formula

PeterM

Hello,

I need help creating a Formula.

I want to pull the number of cases that has a date for a set time like 04/01/2023- 04/30/2023

The two columns are ‘’Case Number’’ and ‘’Submission Date’’. 

Jeff Reisman

@PeterM I would use the COUNTIFS function here:

=COUNTIFS([Case Number]:[Case Number], <> "", [Submission Date]:[Submission Date], <=DATE(2023, 4, 30), [Submission Date]:[Submission Date], >=DATE(2023, 4, 1))

The above would work if the formula is in the same sheet as those columns.

The logic is: Count the rows where the Case Number field is not blank, and where the Submission Date is less than or equal to April 30th 2023, and greater than or equal to April 1st 2023.

Colleen Patterson

@PeterM

For every line where there is a Submission Date, is there a case number?

This would change how the formula would be set up, if that is not the case.

PeterM

@Colleen Patterson

For every line where there is a Submission Date, is there a case number?

Yes, each submission date has a case number.