» Calculating the Number of Business Days in a Specified Period
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: Calculating the number of business days between the dates entered in cells A2 & B2.
Solution:
Use the NETWORKDAYS function as shown in the following formula:
=NETWORKDAYS(A2,B2)
Example:
Date1________Date2___________Business Days
01/04/2005___01/10/2005______131
Book Store:
Recommended Books:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Finance and Accounting for Nonfinancial Managers
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- The New Financial Order: Risk in the Twenty-First Century
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
