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 frustration. Currently using: =DATEDIF(A2,G2,"D") to calculate number of days between dates but can't find the way to add the exclusion of start date when more than 2 days are the returned value. Does this make any sense?


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