How to calculate days difference and excluding Saturday Sunday?
In Excel/Google Sheet, we use NetWorkDays formula. How to do this in Board?
Answers
-
Hi Irwin,
The same function is also available with Nexel, I have used it several times and it works without any issues. It gets more interesting when you want to exclude bank holidays.But if you only want to exclude Saturday and Sunday Nexel is the way to do it.
You can find the complete Nexel Formula Library here: Board Support Desk - Powered by Kayako https://support.board.com/index.php? Help Desk Software
Not sure if you have used Nexel before if not have a look at the Board help website: Nexel
Kind regards,Daniel
10 -
Thank you Daniel, I have never used Nexel before. I just tried it and it works.
Nexel Formula:
Validating in Excel:
9 -
Hi Irwin Tanadi, just in case you ever get to a point where you can't use NEXEL you can also use Networkdays in ETL. We developed a solution for a client back in the pre-Nexel days which uses an export and ascii datareader with networkdays calculated in ETL.
4 -
Thanks Brendan, good to know that we can use Board ETL as well. The NEXEL works fine and preferred in this case.
1
