Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Formula help RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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