Dates calculation using working days

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

Originally Posted by 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

Try this

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

Is this what you need?

oldchippy

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

"Javier" wrote:

> 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