For a range of dates determine the number of days in a specified Month

[klitton7]

For the attached document, I need a formula that will look at a range of dates (columns C & D) and determine if the dates in the row are in the same month as appears in column B. I have added the expected results in column E. Thank you!

 

[Eric W]

Welcome to the MrExcel forum!

Assuming the B1 date is the first of the month:

Book2
	A	B	C	D	E
1	Billing Perios:	Jun-24	From	Through	#Days
2			5/25/2024	6/1/2024	1
3			6/2/2024	6/8/2024	7
4			6/9/2024	6/15/2024	7
5			6/16/2024	6/22/2024	7
6			6/23/2024	6/29/2024	7
7			6/30/2024	7/6/2024	1
Sheet2

Cell Formulas
Range	Formula
E2:E7	E2	=MAX(0,MIN(D2,EOMONTH($B$1,0))-MAX(C2,$B$1)+1)

 

[klitton7]

PERFECT! Thank you

 

[Eric W]

Happy to help!