Answered

Count number of date range exclude weekend

(0) Share

Report

Posted on by YanisaSC

Hi, I created a flow for counting the differences between days. But when I run the flow, the variable in the Increment variable does not start counting 1 in 2023-01-03 but it continues count from the 2023-01-05 and return the results obtained on 2023-01-03 plus the old date.

How can I solve the flow so that it works properly? ,Thank you 🙏🏼.

Flow :

Result :

Problems part :

in 2023-01-05

in 2023-01-03

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report
I would prefer Select and Filter actions over Apply to teach and Condition.

DayDiff: Compose Action with expression:

div(sub(ticks(outputs('EndDate')), ticks(outputs('StartDate'))), 864000000000)

DayArray: Select action:
From:

range(1,outputs('DayDiff'))

Map:

addDays(outputs('StartDate'), item())

WorkDays: Filter action
From:

body('DayArray')

Filter:

@And(greater(dayOfWeek(item()), 0), less(dayOfWeek(item()), 6))

CountWorkDays: Compose action

length(body('WorkDays'))

This counts from StartDate+1 up to and including EndDate.

Was this reply helpful? Yes No
YanisaSC 50 on at

Like (0)

Report

Flow works amazingly!!! .

I've been trying to solve this problem for a week. Thank you very much for helping me.💖

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

You're welcome.
I also considered creating a version in which the number of days is determined directly using a formula.
However, the flow above is more flexible since you get a date array.
For example, you can use it to easily filter for public holidays, visualize the days in a table or calendar, or calculate the hours if they depend on the day of the week.

Was this reply helpful? Yes No