Dates calculation using working days

J

Javier

Hi everybody,

I would like to know how is it possible to subtract 2 diferent dates and
counting only working days inside the formula.

Thank you
 
O

oldchippy

Javier said:
Hi everybody,

I would like to know how is it possible to subtract 2 diferent date
and
counting only working days inside the formula.

Thank you
Click to expand...


Try this

A1 = 01/07/2006
B1 = 31/07/2006
C1 =NETWORKDAYS(A1,B1)
Answer 21

Is this what you need?:)

oldchipp
 
T

Toppers

Look at NETWORKDAYS which is part of the AnalysisToolPak (ATP) add-in. Check
ATP in the Add-ins menu.
 
Top