Count Between Dates

[luis.carrion]

I need a formula to count the numbers of inventory completed during the month of October from Tab SCA FY17 Tab Column J9 (Date Format: 12/1/23) in The Dashboard Tab Column V31

 

[Asala42]

One common method is the COUNTIFS function (plural version of COUNTIF).

eg

=COUNTIFS($A$2:$A$200,">="&Z1,$A$2:$A$200,"<="&Z2)

Where Z1 and Z2 are your start/end dates, and A1:A200 is your list of complete dates.

That said, what date does your example 12/1/23 represent? That does not look like a format excel will automatically recognize as a date, so you may need to do some kind of conversion.

 

[Matt Rogers]

Hi.

IF 12/1/23 = 'MM/D/YY' then perhaps this variant:

Formula F2: (Days between start and end)
=SUMPRODUCT((A2:A10>D2)*(A2:A10 < E2)*(B2:B10))


Formula G2: (Days including start and end)
=SUMPRODUCT((A2:A10>=D2)*(A2:A10<=E2)*(B2:B10))

Excel Workbook
	A	B	C	D	E	F	G
1	Day	$	*	Start	End	Sum1	Sum2
2	11/29/23	10	*	12/1/23	12/4/23	2	202
3	11/30/23	10	*	*	*	*	*
4	12/1/23	100	*	*	*	*	*
5	12/2/23	1	*	*	*	*	*
6	12/3/23	1	*	*	*	*	*
7	12/4/23	100	*	*	*	*	*
8	12/5/23	10	*	*	*	*	*
9	12/6/23	10	*	*	*	*	*
10	*	*	*	*	*	*	*
Sheet