Calculate Business Days between to dates?

T

The Wolf

Can I calculate how many business days are in between to dates? I.e.
Mon-Friday

June 15 to July 15 = 23
 
J

JE McGimpsey

The Wolf said:
Can I calculate how many business days are in between to dates? I.e.
Mon-Friday

June 15 to July 15 = 23
Click to expand...


Take a look at NETWORKDAYS() function in XL Help.

NETWORKDAYS() is an Analysis Toolpak Add-in function (Tools/Add-ins...,
check the appropriate checkbox).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Date Calculation - Astro Calculation 0
Countdown macro - display settings 2
How To Calculate the Number of Fridays between two dates. 5
number of months and days between two dates without approximation 3
calculating age of debt (30,60,90 days) 1
Month days over a time period 5
Revenue for month 0

Top