Frequency of dates in a date range

[Wx4usa]

I'm so stumped. I have a list of service calls. Column A is the Date. Columns B through X are just data related to the calls. On a report, I have Start_Date and End_Date. I need a formula that returns the number of days we had service calls...This is the number of days worked. We are not necessarily open or running calls 5 days a week. So how do I get Excel to count how many days had service calls between 2 dates using my start_date and end_date? So if I had 36 service calls spread out and listed on 36 lines with dates of August 1, 2 ,4 ,7, 10, 11,12, 15. And my start_date is 8/1/20 and my end_date is 8/15/20 Excel should return 8 days worked. Make sense?

 

[CA_Punit]

Try This

Book1
	B	C	D	E	F	G	H
3				Start Date	End Date
4		Dates		01-08-2020	15-08-2020
5		01-08-2020
6		02-08-2020				8
7		04-08-2020
8		07-08-2020
9		10-08-2020
10		11-08-2020
11		12-08-2020
12		15-08-2020
13		18-08-2020
14
15
16
17
Sheet1

Cell Formulas
Range	Formula
G6	G6	=SUM(--ISNUMBER(MATCH(ROW(INDIRECT(E4&":"&F4)),$C$5:$C$13,0)))

 

[Wx4usa]

That's it. You are awesome. Thank you so much!

 

[CA_Punit]

You are most welcome..