How to calculate days difference and excluding Saturday Sunday?

Irwin Tanadi

In Excel/Google Sheet, we use NetWorkDays formula. How to do this in Board?

Daniel Zillmann

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

Irwin Tanadi

Thank you Daniel, I have never used Nexel before. I just tried it and it works.

 

Nexel Formula:

 

Validating in Excel:

Brendan Broughton

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.

Irwin Tanadi

Thanks Brendan, good to know that we can use Board ETL as well. The NEXEL works fine and preferred in this case.