+ Reply to Thread
Results 1 to 2 of 2

Counting active projects at any given time

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Clemson, SC
    MS-Off Ver
    Excel 2010
    Posts
    5

    Counting active projects at any given time

    I am trying to plot the number of projects that were active on a monthly basis across a two year period.
    Each row represents an individual project which includes the start and finish dates for that project.
    My final worksheet has about 500 project entries.

    I've attached a file which shows my worksheet layout along with a graph which represents the output I would like to see.

    Thanks in advance for your assistance.

    MB
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2405
    Posts
    13,434

    Re: Counting active projects at any given time

    Mr Bee given that the expected count for Jan 17 is 1 I would guess the intended start date in B2 is 1/1/2017 and not 1/2/2017. All others start on the 1st of the month. This will return 0 for Jan without that change.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This also works.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Time report for projects.
    By KBergmar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2016, 08:50 AM
  2. Formula to count number of active projects
    By RattlerSkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2016, 04:08 PM
  3. Time analysis on projects
    By noceps in forum Excel General
    Replies: 3
    Last Post: 03-26-2014, 05:24 AM
  4. Stacked Bar for Late vs. On-time projects
    By Ezekedes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2014, 12:18 PM
  5. Replies: 8
    Last Post: 02-27-2013, 02:16 PM
  6. Tracking if projects are late or on time
    By YZ5550 in forum Excel General
    Replies: 5
    Last Post: 10-17-2012, 05:39 PM
  7. How to chart active projects per week in Excel 2007
    By FilliamHMuffman in forum Excel General
    Replies: 1
    Last Post: 03-26-2009, 03:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1