cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude weekends from DateDiff

Please make DateDiff Exclude weekends. It can't be done reliably by any coding like mentioned here

 

https://powerusers.microsoft.com/t5/General-Discussion/Excluding-weekends-using-DateDiff-and-Datepic...

 

We need function or extend datediff function to make it reliable. We also need option in datediff to exclude other days then weekends.

For example if we have app for booking holidays. Each shift works different days. Morning shift monday to friday and night shift monday to thrusday. We need to calculate how many days they booked

Status: New
Comments
Helper II

The feature would very desireable in calculating vacation days taken.

 

datediff - weekends - statutory holidays.

 

ie. taking off July 1, 2019 to July 8, 2019 inclusive (Saturday, July 6, Sunday, July 7, removed, plus Thursday, July 4 removed)