Results 1 to 6 of 6

Count past due Milestones based on 2 criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    371

    Count past due Milestones based on 2 criteria

    I manage projects which each has milestones (M1- M11). Each milestone has 2 columns - planned and actual. What I want is to count the milestones that are past due, based on current date (today). The PLN column shows the planned date the milestone should be met. If it is met, the ACT column will be populated with the actual date it was completed. Since I have hundreds of projects, I want to summarize (COUNT) in a table (sheet2), how many are past due per milestone....

    The Criteria to COUNT:

    1. The milestone date is past due (based on TODAY date)
    2. The ACTUAL milestone (adjacent column) cell is empty - no date populated

    In the attached file, I provided an example... I don't know which formula would scan both criterion...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with If formula to ignore data based on past criteria.
    By jtmoore in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-22-2014, 03:33 AM
  2. Copy and Past Entire Row based off of Criteria into new Worksheet
    By KLiving in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-25-2013, 09:51 AM
  3. Color coding cells based on due dates for a series of milestones
    By popeye2295 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-05-2013, 04:24 PM
  4. [SOLVED] Macro to take certain rows of data based on set criteria and past in to an existing sheert
    By Petmol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2013, 01:30 AM
  5. [SOLVED] Percentage based on the completion of the milestones
    By chriseverclear in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2012, 12:16 PM
  6. copy and past to different sheets based on criteria
    By rz6657 in forum Excel General
    Replies: 4
    Last Post: 10-05-2010, 11:56 AM
  7. [SOLVED] Count data based on past dates
    By JimDandy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2006, 10:59 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