How I calculating working days

[Centauro]

Hi I need calculating how many working days (Mo - Fr) has past from une date
to another

if tony start in 01/01/2008 an finish in 22/08/2008 = 179 working days

Tks

 

[T. Valko]

if tony start in 01/01/2008 an finish in 22/08/2008

= 179 working days

I think the correct answer is 169

Try one of these:

A1 = start date
B1 = end date

This formula requires the Analysis ToolPak add-in be installed:

=NETWORKDAYS(A1,B1)

Or this one:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6))

 

[T. Valko]

Clarification:

This formula requires the Analysis ToolPak add-in be installed:
=NETWORKDAYS(A1,B1)

That formula requires the Analysis ToolPak add-in be installed for Excel
versions prior to Excel 2007.