Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Im trying to summarise the number of NETWORKDAYS spent on projects by month.
The data I have is as follows: (dates are in UK format) A B C 1 Project Name Start Finish 2 Project One 22/02/2008 13/03/2008 3 Project Two 22/02/2008 06/03/2008 4 Project Three 25/02/2008 11/03/2008 5 Project Four 25/04/2008 12/05/2008 6 Project Five 09/05/2008 06/06/2008 7 Project Six 13/05/2008 27/05/2008 The result I am looking for should look like this: 9 Month Number of Days 10 January 2008 0 11 February 2008 17 12 March 2008 20 13 April 2008 4 14 May 2008 35 15 June 2008 22 I have tried various combinations of arrays using SUM, SUMIF etc but cannot find a solution. Any advice would be appreciated. Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Counting no of days from a list of running dates for a 12 month pe | Excel Discussion (Misc queries) | |||
Calcualtion days in month from 2 dates | Excel Worksheet Functions | |||
Number of Days in the Month | Excel Discussion (Misc queries) | |||
Dates - Several Days In a month to month only | Excel Discussion (Misc queries) |