Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Formula to Find Number of Weekdays Between Dates

XL2000: Formula to Find Number of Weekdays Between Dates

View products that this article applies to.

This article was previously published under Q214141

↑ Back to the top

Summary

This article describes a simple formula to calculate the number of weekdays (workdays) between two dates.

↑ Back to the top

More information

You can use the following formula to find the number of weekdays between two dates, where cell A1 contains the beginning date and cell A2 contains the ending date:
=NETWORKDAYS(A1,A2)
If the NETWORKDAYS function is not available, you must run the Microsoft Excel Setup program and install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

↑ Back to the top

References

For more information about the NETWORKDAYS function, click Microsoft Excel Help on the Help menu, type networkdays in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB214141, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 214141
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 268