You could use adysBetween to calculate the number of days.
And a loop using a merge to create an object for each day.
Something like this?
You could indeed use a loop construction in a microflow, using addDays($variable,1).
If you want to take into account holidays, besides weekend days, I would propose a Day entity. Make pages so you can manage the days. Then use it by querying the database like [date >= 13/07/2020 and date <= 17/07/2020 and working_day = true]. When using the aggregate microflow action to counting the number of days, this should be a well performing query.
Made it :) Thanks to all :)