difference in business days between dates minus a number

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I use the following as the default in a text field to calculate the difference between 2 dates in business days and it works well an

With(
 {
 // generate a one-column table of all dates between start date & end date
 gblDateRange: ForAll(
 Sequence(dpEnd.SelectedDate - dpStart.SelectedDate + 1),
 dpStart.SelectedDate + Value - 1
 )
 },
 If(
 And(
 IsBlank(dpStart.SelectedDate),
 IsBlank(dpEnd.SelectedDate)
 ),
 // show nothing if any date pickers are blank
 0,
 // include only dates Monday to Friday
 
 CountIf(
 gblDateRange,
 Weekday(Value) in [
 2,
 3,
 4,
 5,
 6
 ]
 )
 )
)

I now need to take .5 off the figure if the following localVariable is true

conHalf

Is this possible?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If( conHalf, CountIf( gblDateRange, Weekday(Value) in [2, 3, 4, 5, 6] ) - 1, CountIf( gblDateRange, Weekday(Value) in [2, 3, 4, 5, 6] ) ) ) )