Updated: Jul 13, 2021
We will be using the NETWORKDAYS Function for our Waterfall Web Development Process timeline example to calculate the number of workdays. Saturday and Sunday are excluded in NETWORKDAYS Function.
We will also show you how to convert your NETWORKDAYS function into an API at the end of the video.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
Excel Template: https://www.alchemyj.io/aj-excel-template
Learn More: How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ
Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/
What is a NETWORKDAYS Function in Excel? A NETWORKDAYS Function “Returns the number of whole workdays between two dates”. Do keep in mind that Saturday and Sunday are excluded in NETWORKDAYS Function. We will be using the Waterfall Web Development Process timeline in our tutorial and calculating the number of workdays. We will need to have the start date, end date and holiday for our web development process calculation. Without further ado, let us start the calculation and get our website up and running.
How to use NETWORKDAYS Function
Select Cell E7, type in the equal, type in NETWORKDAYS, open parentheses. Select start date in Cell C7 and type in a comma. Select your end date in Cell D7 and type in a comma. Next, we will add in the Holiday. Move your cursor to Cell H5. Select and drag your cursor from Cell H5 to H14. We will also make this range into an absolute cell reference by clicking on our F4 Button Lastly, Close parentheses and hit return. You will get 20. The number of workdays for Requirements Analysis.
Now, let us find the number of workdays for the other web development process. Let us use the auto-fill function. Move your cursor to the lower right of Cell E7. Once your cursor turns to a plus sign. Double click on it. You will get the number of workdays for the rest of the web development process.
There you have it, the NETWORKDAYS function for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorial. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.
Convert NETWORKDAYS function into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this NETWORKDAYS Function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select the AlchemyJ ribbon, select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will now launch this openAPI which AlchemyJ generates, and try using the NETWORKDAYS Function on it. I will expand this tab and select try it out. Let’s try to start by Web Development Process with Requirement Analysis, the start date will be 1 January 2021, and the end date would be 31 January 2021. Let’s see if we can get 20 NETWORKDAYS. Awesome, we got it.
AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.