Days In Incarcerated Field

1. First we added a new column called "DaysIncarcerated"

2. After finding the columns for the Arrest Date (B2) and the Release date (F2), and then applied this formula on all of the rows.

=IF(AND(F2<>"",B2<>"",F2>B2,F2-B2<5000),F2-B2,0)

The formula sums up all rows that meet the following conditions:

• The row has release date
• The row has an arrest date
• The row's release date subtracted by the arrest date is less than 5000.

Everything else is given a value of 0.

We then copied and pasted the values of the "DaysIncarcerated" column. Next, we did a "Find and Replace" to make sure that any "#VALUE!" was removed.