Calculation of days

B

BBroswick

In column A are a series of consecutive dates, as an
example A1=1/15/04, A2=1/26/04, A3=2/3/04, etc. In Column
B I want to show the number of week days between dates
minus the week-end dates. Again, using my initial
example, in column B1 I am intending to show the number of
days between A1 and A2, which in this case B2=7 (11 total
days minus 4 weekend days). Any thoughts on the correct
formula to accomplish this would be most appreciated.
 
M

Myrna Larson

Use the NETWORKDAYS function. It also accommodates a list of holidays.

You have to install the Analysis Tool Pak to use it. See Help for the function
for more informatin.
 
D

Domenic

=NETWORKDAYS(A1,A2)-1

You'll need to ensure that the Analysis ToolPak is enabled...

Tools > Add-Ins > check Analysis ToolPak > Click Ok

Also, this function allows you to exclude holidays from the calculation.
See the Help menu for details.

Hope this helps!
 
F

Frank Kabel

Hi
=NETWORKDAYS(A1,A2)

Bote: You must have the Analysis Toolpak addin installed for this
function
 
Top