XL2000: Formula to Find Number of Weekdays Between Dates

View products that this article applies to.

This article was previously published under Q214141

Expand all | Collapse all

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