
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2017 05:59 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 19, 2020 10:59 AM
That’s an awesome solution. Thanks very much!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 13, 2020 09:19 AM
Also looking for a solution like this! (like McKenna_Johnson)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 20, 2021 07:49 AM
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?

- « Previous
-
- 1
- 2
- Next »