Consulting | Excel Examples
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.