Help with categorizing a period into month and days

Hi, i would like some guidance to make an excel that the user inputs a period like 12/2/2022-5/4/2022 and the excel categorize it into seperate months with the days in the next cell. For example for the previous period :February 17days//March 31days//April 5days. Any help will be appreciated.Thanks in advance

With Start date in A2 and End date in B2

with C1

01/01/2022 then D1

=EOMONTH(C1,0)+1 and copy across

in C2

=IF(EOMONTH($A2,0)=EOMONTH(C$1,0),EOMONTH($A2,0)-$A2+1,IF(EOMONTH($B2,0)=EOMONTH(C$1,0),$B2-EOMONTH($B2,-1),IF(AND(C$1>$A2,C$1<$B2),EOMONTH(C$1,0)-EOMONTH(C$1,-1),0)))

copy across

in B5

=IF(EOMONTH($A$2,0)=EOMONTH($A5,0),EOMONTH($A$2,0)-$A$2+1,IF(EOMONTH($B$2,0)=EOMONTH($A5,0),$B$2-EOMONTH($B$2,-1),IF(AND($A5>$A$2,$A5<$B$2),EOMONTH($A5,0)-EOMONTH($A5,-1),0)))

First convert your text months to numeric dates. In A5 1/2022 would be fine for the first date. Then in A6

Formula:

=EDATE(A5,1)

and copy down.

Try this in B5 and copy down.

Formula:

=INDEX(FREQUENCY(ROW(INDIRECT(A$2&":"&B$2)),EOMONTH(A5,{-1,0})),2)

Another way in B5 and copied down.

Formula:

=MAX(0,MIN(INDEX(IF(MUNIT(2),EOMONTH(A5,{-1,0})+{1,0},A$2:B$2),,2))-

MAX(INDEX(IF(MUNIT(2),EOMONTH(A5,{-1,0}),A$2:B$2),,1))+

(EOMONTH(A5,-1)=EOMONTH(A$2,-1)))

Doesn't work ?? See attached