Challenge! Fiscal Year vs Calendar Year Days Overlap

Question

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!

Fiscal Year vs Calendar Year Days Overlap.yxzp

Qiu · Answer

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

New Workflow2-r2.yxmd

chilby · Answer

@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 · Answer

@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.

New Workflow2-r1.yxmd