Number of working days between two dates (without weekends)

[Adnan_Halilovic]

Hello,

I’m trying to solve the following problem:
I have created a table which has 2 columns {DATE FROM} and {DATE TO}}. The third one I have is called {WORKING DAYS}, so that one should show a number of working days between selected dates (from and to).

The problem I’m having is that I cannot calculate number of working days between them (without weekends), I can just get all days, which is not useful for me in this case…

Is there any chance to solve it?

WORKDAY() function doesn’t help, since it just creates a due date when I enter parameters.

I could solve my issue, if there are for loop, for each, or any other loop functions in the functions menu.

Thank you

[bjenkins]

W_Vann_Hall:

DATETIME_DIFF({Date to},{Date from},'days')-
(INT(DATETIME_DIFF({Date to},{Date from},'days')/7)+
IF(DATETIME_FORMAT({Date from},'E')>DATETIME_FORMAT({Date to},'E'),1,0))*2

That’s an awesome solution. Thanks very much!

[Quentin_Bonte1]

Also looking for a solution like this! (like McKenna_Johnson)

[Jorge_Chavez]

I have used this formula with the following dates however, the outcome was not as expected.

WORKDAY_DIFF({Date Received}, {Date Completed})*24
Date Received = 16/7/2021 10:23am
Date Complete = 20/7/2021 10:23am

The result should had been 48 but instead I got 72. Can you please advise why?