There may be a more efficient way to do this, but I have a way that works. this also could be better with the new Sequence formula, but that isn't in my environment yet.
So I add a date picker for the date to calculate business days from
Add a text input field set to number format for the number of business days from date to calculate
Add the following on change of the date picker
ClearCollect(
DateRange,
AddColumns(
FirstN(
[
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29,
30,
31,
32
],
DateDiff(
DatePicker1.SelectedDate,
DatePicker1.SelectedDate + 90,
Days
) + 1
),
"Day",
"Day " & (Value + 1),
"Date",
DateAdd(
DatePicker1.SelectedDate,
Value,
Days
),
"Week_Date",
Weekday(
DateAdd(
DatePicker1.SelectedDate,
Value,
Days
)
)
)
)
this gives us a collection of 90 calendar days from the specified date.
Then I add a gallery to the canvas and set the items property to
Filter(DateRange,Week_Date>1,Week_Date<7)
Set the visible property of the gallery to false--we don't need to show it , we just use that to get a filtered list of days excluding Saturday and Sunday.
Then where you want to get the day after the
business date that falls on the specified day interval, use the following formula:
Last(FirstN(Gallery2.AllItems, Value(TextInput1.Text)+1 )).Date
@unislacker if this answers your question, please mark it as a solution.
