1 Reply Latest reply on Mar 7, 2018 11:51 AM by joy.delosreyes

    calc date days and filter dates

    Robert Wisler

      I have 2 questions.

       

      Attached is a sample workbook.

       

      Question 1 - how do i calculate the days in between the different member ID's. currently i have a formula to calculate the days in between the date above it (which is the formula in the same workbook). I want to calculate the number of days by individual member ID.

       

      Question 2. on the same workbook, under the question 2 table. Is there anyway to filter out the member ID and only keep the member ID with 2 or more day of service from dates? the formula would get rid of member id 1234 and member id 123456 but keep 12345 since it has more than 1 date in the service from date