Number of Days for each month in a Date Range

[SYang1]

I'm trying to break down a record into monthly day ranges...How would i do this.....

Turn this....

Account	Category	Date State	Date End	Budget
123	454	1/15/2019	6/15/2019	$6,000

Into this...(Minus total)

Account	Category	Month	No. Days	Total Number Days	Monthly Budget	Date State	Date End
123	454	January	16	151	636	1/15/2019	6/15/2019
123	454	February	28	151	1113	1/15/2019	6/15/2019
123	454	March	31	151	1232	1/15/2019	6/15/2019
123	454	April	30	151	1192	1/15/2019	6/15/2019
123	454	May	31	151	1232	1/15/2019	6/15/2019
123	454	June	15	151	596	1/15/2019	6/15/2019
				Total	6000

[CharlieS · Accepted solution]

The Generate Rows tool is what makes this possible. Check out the attached solution and let me know if you have any questions.

[SYang1]

Thank you!  Exactly what i was looking for.