|
How I calculating working days
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 |
How I calculating working days
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 |
How I calculating working days
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 |
| All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com