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?
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?