cancel
Showing results for 
Search instead for 
Did you mean: 

Add the Networkdays() function to count working days between two dates

Please add the Networkdays function in a similar way to the Excel function that calculates the working days between two dates.

Status: New
Comments
martinav
Super User

Networkdays(), Days(), and similar date functions.  I need this to be able to assess late delivery, and other auditing type of filtering.

CharlesS
Kudo Kingpin

This function should be added directly in the Dataverse calculated fields. Here is a very common use case:

- Must return the estimated delivery date for an order.

- Calculation to be applied: "Ship Date" column in Dataverse + "Shipping Days" column in Dataverse.

- Current formula to use: ADDDAYS (whole number, date and time)

 

The problem of course is that if the Ship Date is on a Friday, and the Shipping Days is equal to 2, the ADDDAYS formula will return a Sunday, whereas in many cases deliveries are not available on weekends.

 

Another typical business use case would be to calculate an estimated ship date based on an order date + estimated lead time (provided in working days). 

Lucian
Advocate III

Well, after four years it seems that nobody need date calculation functions like Excel's Networkdays.

Only 25 votes! 😞

 

I have tried some workarounds like Excluding weekends and holidays in date differences in PowerApps but it has a major bug when start/end date fall on weekend.

 

It should be definitely added to Power Apps Fx Functions.