+ Reply to Thread
Results 1 to 4 of 4

Count days between dates with a criteria

  1. 07-14-2016, 05:16 PM #1
    Macfool
    Macfool is offline
    Registered User
    Join Date
    08-30-2011
    Location
    Australia
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    57

    Count days between dates with a criteria

    I want to count days between 2 dates based on a criteria, I know how to count between 2 dates but this is a rolling list of dates that I need to count. I have dates in column A, the criteria is in column C
    When a new date is entered in column A and if the criteria is met in column C I need to count the days from the last instance. I have attached a workbook with what I am trying to acheive.

    Thanks for any assistance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-14-2016, 05:29 PM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Count days between dates with a criteria

    Can you add a helper column?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
    Reply With QuoteRegister To Reply
  3. 07-14-2016, 05:36 PM #3
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Count days between dates with a criteria

    Here is how I would likely do it, even though I believe your first count should be 8 days and not 9.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-14-2016, 07:46 PM #4
    Macfool
    Macfool is offline
    Registered User
    Join Date
    08-30-2011
    Location
    Australia
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    57

    Re: Count days between dates with a criteria

    Thanks mike that works great.

    Much appreciated
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup dates between two dates and count the number of days
    By nishikanth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2013, 03:25 AM
  2. Count formula for dates greater than 30 days old with exclusions and not count blanks
    By mmennealy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2012, 05:25 PM
  3. Count days between dates based on criteria
    By efernandes67 in forum Excel General
    Replies: 9
    Last Post: 06-23-2012, 04:29 PM
  4. Count days between dates
    By bigband1 in forum Excel General
    Replies: 3
    Last Post: 08-25-2011, 11:49 AM
  5. Count Days from Dates
    By shaka in forum Excel General
    Replies: 3
    Last Post: 05-01-2011, 10:33 AM
  6. Count days between dates
    By Brandy in forum Excel General
    Replies: 9
    Last Post: 08-07-2010, 10:45 AM
  7. Count Working Days between 2 dates, but return a zero if the 2 dates are the same day
    By raehippychick in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2009, 05:04 AM
  8. count the days between two dates
    By Dazza in forum Excel General
    Replies: 1
    Last Post: 04-22-2007, 04:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1