none
Formula help RRS feed

  • Question

  • Good Morning
    I am trying to determine how many days between today object. and the created date of this, but only if the status is not equal to closed. If there is any other status I want Excel to calculate the difference between two cells and return the number of days between dates.
    Originally, I was used the DATEDIF function to calculate the difference between two dates - for example:
    =DATEDIF(Created,TODAY(),"D")
    The problem is it also calculate the closed column.  This is a problem because ultimately I want to calculate the average of the days elapsed between pairs of dates
    

    Monday, November 6, 2017 2:42 PM

Answers

All replies