Calculate Maximum Items Checked out

[jeffwest1230]

I am trying to calculate the maximum number of kits that were checked out at any point in time. My spreadsheet shows the person who check out a kit, the day it was checked out, and the day it was checked in (See attached example). I just can't seem to come up with anything to determine the most kits that were checked out on any given day.