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

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))


--
Biff
Microsoft Excel MVP


"Centauro" wrote in message
...
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

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.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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))


--
Biff
Microsoft Excel MVP


"Centauro" wrote in message
...
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