Days per month from multiple date ranges

[wolftg]

So I'm keeping track of how many days per month my Airbnb is booked
If I have a list of date ranges

1/1/22 - 1/5/22
1/5/22 - 1/10/22
1/11/22 - 1/18/22
2/4/22 - 2/12/22

What is the formula so that I can show days per month

Jan - 15
Feb - 8
Mar

 

[wolftg]

This did not seem to work for me.

Days between two dates separated into days per month

Hello all, I am trying to make an irrigation water demand worksheet for engineers and I am almost finished, but the date entry is perplexing me... I want a user to be able to enter two dates then the days per month between the two populate a column as shown below. For example user enters...

www.mrexcel.com