Completed days in a month based on start date and end date

[Lara_1234]

Experts...I have a data which has start date and end date in 2 columns.. i need to derive completed days in a month based on start and end date .

Start Date	End date	31-Jan-23	28-Feb-23	31-Mar-23	30-Apr-23	31-May-23	30-Jun-23	31-Jul-23	31-Aug-23	30-Sep-23	31-Oct-23	30-Nov-23	31-Dec-23
01-Jan-23​		31	28	31	30	31	30	31	31	30	31	30	31
01-Jan-23​	15-Sep-23​	31	28	31	30	31	30	31	31	15	-	-	-
10-Apr-23​	15-Sep-23​	-	-	-	22	31	30	31	31	15	-	-	-

 

[Juniad]

Try this formula
=SUMPRODUCT((ROW(INDIRECT($A2&":"&$B2))>=EOMONTH(C$1,-1)+1)*(ROW(INDIRECT($A2&":"&$B2))<=C$1))
See the attached workbook.

 

[p45cal]

Or, stealing @Juniad 's file, in C3:

=MAX(0,MIN(C$1,$B2)-MAX($A2,EOMONTH(C$1,-1)+1)+1)

copied down and across.

 

[Lara_1234]

Thanks guys, this is great