Results 1 to 6 of 6

calculate elapsed days against criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    29

    calculate elapsed days against criteria

    Hi all, I have two columns of data. The first column is the unique identifier for the subject, the second column is the date of interaction with that subject.

    One subject can have several interaction dates. I'm trying to figure out a way to calculate the elapsed days from the first date of interaction to the last, for that subject. I've got MAX(date)-MIN(date), but I can't work out a way to make that calculation relate only to the unique identifier in that dataset.

    For example:
    1.png

    for this example, I manually worked out that the elapsed days for subject 1 is 61, for subject 2 is 50, subject 3 is 44.

    I need a formula that will make this calculation per subject in column C, for example:
    2.png

    Thanks in advance, R
    Last edited by coffee_man; 03-12-2015 at 05:45 AM. Reason: clarification

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate days elapsed based on criteria from other cells
    By jmcnea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 12:09 PM
  2. Need macro to calculate number of days elapsed between data in two columns
    By kang6789 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 06:32 PM
  3. How to calculate elapsed time between to days excluding weekends.
    By Mush001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-23-2009, 04:19 PM
  4. How to Calculate Days elapsed where Weekend is calculated as 1 Working Day?
    By speakbones in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2007, 07:20 PM
  5. Calculate elapsed working days
    By RUSH2CROCHET in forum Excel General
    Replies: 6
    Last Post: 03-09-2006, 04:40 PM

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