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:
9/22
9/23
9/24
10/1
10/2
10/7
10/21
10/22
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!
Thank you!