LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Sum the number of days between dates by Month

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of days in month counted from shortened name of month & yea Tumar Excel Worksheet Functions 6 September 18th 07 03:36 PM
Counting no of days from a list of running dates for a 12 month pe bill999 Excel Discussion (Misc queries) 2 June 9th 07 10:35 AM
Calcualtion days in month from 2 dates phocused Excel Worksheet Functions 10 December 22nd 06 11:43 AM
Number of Days in the Month Beth Excel Discussion (Misc queries) 2 March 2nd 06 03:44 PM
Dates - Several Days In a month to month only Andy_Pimp Excel Discussion (Misc queries) 1 February 28th 06 11:11 AM


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"