Solved: Workdays between 2 dates - Page 2

1minManager · 04-20-2021 09:14 AM

Just wondering if anyone has a formula for calculating the number of Workdays beween 2 dates? Including both those dates. If its relevant, the Start and End dates may be a weekend

Marc_Dillon

We have the WORKDAY() expression.

For convenience, assume another column “total days” which is equal to:
TOTALHOURS( [end] - [start] ) / 24

Then get total work days with:

[total days]
-
(
  TOTALHOURS( WORKDAY( [start] , [total days] ) - [start] ) / 24
  -
  [total days]
)

Please test well.

View solution in original post