Challenge! Fiscal Year vs Calendar Year Days Overlap

[chilby]

The first input has 13 four week business fiscal periods. The second input includes example dates for 12 billing service periods from an electricity company. I would like to know how many days from each electrical bill fall within each of the 13 fiscal periods. This is relevant for accounting accrual research purposes. Any help you can provide is greatly appreciated!

[Qiu]

@chilby 
I use Generate Rows tool to expand the billing day after converting the Start and End to DateTIme format.

Then do an Append to the Period from them we can filter the days falling between the Period Min and Max.

[chilby]

@Qiu  Thank you for trying to help me solve my problem. 

My desired output columns are:

Period Start Date | Period End Date | Billing Month # | Billing Days Within Fiscal Period

Does that make sense?

[Qiu]

@chilby 
Maybe like this? I just did minor change in the Summarize tool