You can also have it exclude weekends and holidays too. Select a blank cell and type this formula WORKDAY A2B2 and press Enter key to get result. The last 2 are optional but that is where the function shines and differs from the Networkdays function.
The NETWORKDAYS function calculates the difference between two dates excluding weekend days Saturdays and Sundays.
The NETWORKDAYS function counts the number of working days business days between two dates automatically excluding weekends Saturday and Sunday and optionally excluding holidays. It excludes weekends as well as any holidays you specify. The 3 scenarios are counting workdays excluding Saturdays and Sundays as weekends counting workdays excluding specific weekends and counting workdays excluding. The Excel NETWORKDAYS Function If youd like to calculate the difference between two dates while excluding weekends and holidays use the NETWORKDAYS function instead.
