This tutorial explains how to use Excel Networkdays Function to exclude weekend and holiday.
Excel Networkdays function to exclude weekend and holiday
Excel Networkdays Function literally means "net working days", which calculates the number of days between two specific days, excluding weekend (Saturday and Sunday) and holiday. Both start date and end date inclusive.
For example, from Jan 1st, 2015 (Thu) to Jan 5th, 2015 (Monday), total number of Networkdays is three. The function counts...
Read More