Counting days in each month for a period of dates (e.g. 8 Jan to 19 Apr)

I have a list of period of dates and wish to have a day count of each month consolidated for all the periods.

e.g.
Column 1:
8 Jan
9 Feb
16 Mar
19 Mar

Column 2:
19 Apr
18 Mar
20 Jul
30 Aug
*HOWEVER, this date is not account as a value
(e.g. for the first period of 8 Jan to 19 Apr, 18 Apr is counted, but 19 Apr is not counted as a day)

This is the result I seek:
Jan = A number of days accumulated in all above 4 periods of dates
Feb = B number of days
Mar = C number of days
Apr = D
May = E
Jun = F
Jul = G
etc.

Thank you very much.

kyc

i uploaded the file from my computer onto "Manage Attachments", but afterwards I cannot select it in "Attachments" Icon in the reply message.

I think it already is attached however.

Otherwise, does this link work?
excelforum.com/attachment.php?attachmentid=721530&stc=1&d=1614749261

I do not know how to use sumifs, very basic user.

Thanks.

Thank you.

When i viewed your formula, it turned into "Error" after clicking out of it (without any amendment).

I have tried it on my own as well but it shows the same (attached).

Could you identify where is the error from, so that I know what to look out for on my own worksheet?

Thank you.

Magic! Thank you works wonders!

Can you please mark as SOLVED (see Thread Tools at to of page.