Greetings,
In a large list of data, I need to compute the longest gap in a list of dates for each department.
Department 1 1/1/2010
Department 2 2/1/2010
Department 1 3/1/2010
Department 2 3/1/2010
Department 1 4/1/2010
Department 2 3/2/2010
From the sample list above, I would expect that the result for Department 1 to be 59, and for Department 2 to be 28.
Any thoughts?
Bookmarks