Answered by:
Formula help

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
- Moved by Dave PatrickMVP Monday, November 6, 2017 2:56 PM
Monday, November 6, 2017 2:42 PM
Answers
-
I'd ask for help over here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Dave PatrickMVP Monday, November 6, 2017 3:12 PM
- Marked as answer by Richard MuellerMVP Monday, November 13, 2017 3:32 PM
Monday, November 6, 2017 2:58 PM
All replies
-
I'd ask for help over here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Dave PatrickMVP Monday, November 6, 2017 3:12 PM
- Marked as answer by Richard MuellerMVP Monday, November 13, 2017 3:32 PM
Monday, November 6, 2017 2:58 PM -
Ask in this forum:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel
Richard Mueller - MVP Enterprise Mobility (Identity and Access)
- Proposed as answer by Dave PatrickMVP Monday, November 6, 2017 3:12 PM
Monday, November 6, 2017 2:58 PM -
Thank youMonday, November 6, 2017 3:09 PM
-
You're welcome.
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.Monday, November 6, 2017 3:12 PM