NETWORKDAYS.Intl Function in Excel – how can I use this function in my worksheets?
This week’s hint and tip is about the NETWORKDAYS.Intl function in Excel and how you can use it in your worksheets. This isn’t covered on any of our courses so we decided to do a hint and tip on it. We are going to go through it now below.
NETWORKDAYS.Intl Function in Excel
In this blog we shall look at the very flexible NETWORKDAYS.INTL function. It can be used for calculating days in a range of dates.
Many people have come across NETWORKDAYS which also looks at the difference in days between a Start Date and End Date but that function always omits both Saturdays and Sundays in a range. Whereas NETWORKDAYS.INTL is more flexible as you specify which part of the working week is effectively a weekend day!
In the example on our video and below you can see the breakdown of the function:
- Start Date 24/05/21 E1
- End Date 01/06/21 E2
- Weekend 11 (means just class Sunday as a non working day). A list of these values can be seen from the Help hyperlink at the bottom left of the box
- Bank Holiday 31/05/21 E3 (formula says E3:E4 in video to allow for an extra holiday cell but it wasn’t used or needed in the end. So you can ignore the :E4 part)
These 4 arguments above are filled in.
The answer is 7 working dates which are: 24th, 25th, 26th, 27th, 28th, 29th (May) and 1st (June)
We hope you find this useful at some time.
The video below shows you how to actually use this function in a spreadsheet. We hope that you find the video useful and enjoy learning about it!
Take a look below at the video to find out more and then try it out on your own computer!
Click on button to the right to download the example spreadsheet shown in the video to try it out yourself!
We hope you have enjoyed this hint and tip on NETWORKDAYS.Intl function in Excel. Why not take a look at our previous one on protecting documents in Word?