Consulting | Excel Examples

Using Built-In Workday Calculation Functions

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.


Last modified: May 21, 1996