Keywords: Workday, Networkdays, Holidays, Dates
Description: Example of using workday and networkdays functions
Tip: You can use Excel's built in Workday and Networkdays functions to perform calculations with dates taking into account weekends and holidays. Workday returns a date some number of workdays in the future. Networkdays calculates the number of workdays between two dates.
Guide to the Example:
The Workday Functions worksheet contains named ranges -- and the
names are used in the example Workday and Networkday functions.
Use menu option Insert, Names, Define to understand how the named
ranges are defined.
Download File: Click Here
Tip: Click on the link above and choose
"Save" to download the xls workbook to your hard drive or "Open" to
open the workbook inside of your browser.
