Count days per month within interval

[jg33]

Hello!

I'm wondering how I count numbers of days per month month within a dateinterval?

Here is an exempel of how I want it.

A B C D E F

1. Start date End date Jan Feb Mar Apr

2. 01-15-2019 04-08-2019 17 28 31 8

I have the start date and the end date to begin with. And also in cell C1 it says 01-01-2019 and not just Jan and so on for the rest of the months.

I have tried this formula: =MAX(0,(MIN($A2,DATE(YEAR(C$1),MONTH(C$1)+1,0))-MAX($B2,C$1)+1))

However, for January I get the number 31 instead of 17.

Anyone have a solution?

Thanks!

 

[Dave Patton]

T202004a.xlsm
	A	B	C	D	E	F	G	H
1	Start	End	Total	Jan-19	Feb-19	Mar-19	Apr-19	May-19
2	15-Jan-19	08-Apr-19	84	17	28	31	8	0
3
2a

Cell Formulas
Range	Formula
C2	C2	=B2-A2+1
D2:H2	D2	=MAX(0, MIN(EOMONTH(D$1, 0), $B2) + 1 - MAX(D$1, $A2))

 

[jg33]

Hi! Thanks for trying to help! However, now instead of getting the number 31 för january it just says "jan-00".
Also, what is the purpose of calculating C2?

 

[jg33]

ah i see what i did wrong by getting jan-00. However, now it stills says 31. Just like before...

 

[Dave Patton]

try copying the suggestion onto a new sheet
review the formula; you can use Excel's formula evaluate if you want
ensure you format only the dates as dates