I have a list of dates. The list has chronological gaps in it, but I'm looking to bring it all into a single cell of date ranges separated by commas, organized by consecutive dates.
Example of the list:
So in this example, the final cell would look something like this:
9/22-9/24, 10/1-10/2, 10/7, 10/21-10/22
Any ideas? I'm desperate!