Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel