I have a long list of dates (in order, in one column; oldest at the top), about 240, which are entered when an event happens. These might happen twice in one day, or have a gap of several months. What I'd like to be able to do is find the smallest and biggest gap between dates.

So I'm guessing a means of searching down the list, comparing each with the one before (above) it, and finding the smallest gap in the list (probably 0) and the largest. If it could also be modified to search certain date ranges within the list (e.g. the previous 12 months) that would be excellent, but not vital

Very grateful for any and all help, this has proven very tricky