How I calculating working days

  • Thread starter Thread starter Centauro
  • Start date Start date
C

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
 
if tony start in 01/01/2008 an finish in 22/08/2008
= 179 working days
Click to expand...

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))
 
Clarification:
This formula requires the Analysis ToolPak add-in be installed:
=NETWORKDAYS(A1,B1)
Click to expand...

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