- Hot Topics
Excel Date Calculation with exceptions
I have created a log that will calculate number of days between an inmate's intake date and release date using Excel 2010. BUT, when the inmates are taken in, I don't want the day of intake to be counted EXCEPT when the inmate is taken in and released on the SAME date. I don't know how to make the formula count days when there are two or more days, but NOT count the day of intake. I am using the hidden DATEIF function. I'm sure this is a "duh" for most of you, but for me it has been a three-day constant fr
This question generated 14 answers. To proceed to the answers, click here.
This thread is current as of September 23, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel