2,297
This is the form I'm using:
Where the start date is DateValue5 (january, 1, 2023) and the end date is DateValue6 (january, 6, 2023).
I want to calculate the number of working days as per this Microsoft Power Apps blog post.
Thus:
Share
ReportRoundDown(
DateDiff(DateValue5.SelectedDate, DateValue6.SelectedDate, Days) / 7, 0) * 5 +
Mod(5 + Weekday(DateValue6.SelectedDate) - Weekday(DateValue5.SelectedDate), 5)
Should return 5.
But it is returning 0, which is obviously wrong.
Can anyone help?
I've just figured out that this expression works much better.
All responses (
Answers (
With(
{
// generate a one-column table of all dates between start date & end date
varDateRange: ForAll(
Sequence(dte_EndDate.SelectedDate - dte_StartDate.SelectedDate + 1),
dte_StartDate.SelectedDate + Value - 1
)
},
If(
And(
IsBlank(dte_StartDate.SelectedDate),
IsBlank(dte_EndDate.SelectedDate)
),
// show nothing if any date pickers are blank
0,
// show only dates Monday to Friday and exclude holidays
CountIf(
varDateRange,
And(
Weekday(Value) in [2, 3, 4, 5, 6],
Not(Value in 'Holiday Calendar'.HolidayDate)
)
)
)
)
Thanks @mdevaney 😉
