How to Pro-rate hours that overlap two months in a given week?

[sheidari]

Anyone have any ideas on how to solve this? Attached is the sample workflow I created but it doesn’t work as soon once you add another employee with the same week ending period so I’m open to new suggestions. 

the problem I’m trying to solve: I need to pro-rate hours that overlap two months in any given week. 

example: if you have 35 estimated hours for week ending 4/3/2021, then 20 of the hours should move to the prior period, 3/27/2021, since 4 of the days falls into March. the remaining 15 hours should stay in the current period. 

[Luke_C]

I think this is the same as https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-join-two-many-to-many-tables-th...

The solution attached there should work for multiple employees.