Count days in any given month between two dates

[Treklogg]

I am trying to make a list that tells me how many of the days within a periode is in a given month.

Attached picture illustrates how i want the output (column D).

Any good ideas?

[#2]

@Treklogg 

=IFERROR(DATEDIF(MAX(DATE(2022,5,1),B2),MIN(DATE(2022,5,31),C2),"d")+1,0)

Maybe with this formula.

 

[#3]

@Treklogg 

As variant

=SUM( --(MONTH( SEQUENCE([@End]-[@Start]+1,,[@Start]) ) = 5 ) )