Create dynamic rolling sum by day while differentiating between months

[maximilianw]

Hello, I would be glad if someone could help me out :)

I need a workflow for this task:
There are several current contracts that end at different times. It is necessary to calculate the workload of the department in total working days per month. For example, 114 working days in February. The calculation should differentiate between international and domestic contracts. The calculation should be dynamic, because every month orders are added and also orders end. The time horizon is 12 months, which means that if you start the workflow in February 2023, it should calculate the workload of the department until February 2024. One employee is responsible for one order.

Have a look at the simple excel file please.

[FrederikE · Accepted solution]

Hey @maximilianw,

This approach should work. We get Workdays per Month and "Contact X"

[maximilianw]

Hey, thanks for the quick response. However unfortunately something doesnt add up. I calculated the wroking days for april 2023 manually and got different results than from the workflow. I assumed that every month has 31 days. Please take a look at the screenshot with my calculation.