Hello,
in the data set below, how can I group to determine the number of episodes where all of the consecutive dates would be in a group?
Name Date
Joe 1/29/2019
Joe 1/30/2019
Joe 1/31/2019
Joe 2/1/2019
Joe 2/2/2019
Joe 2/3/2019
Joe 3/1/2019
Joe 3/2/2019
Joe 3/3/2019
Joe 3/4/2019
Joe 3/5/2019
Joe 5/29/2019
Joe 5/30/2019
Joe 5/31/2019
Joe 6/1/2019
So the person above would have three episodes. One from 1/29-2/3, a second from 3/1-3/5, and a third from 5/29-6/1.
Thanks for your help.
in the data set below, how can I group to determine the number of episodes where all of the consecutive dates would be in a group?
Name Date
Joe 1/29/2019
Joe 1/30/2019
Joe 1/31/2019
Joe 2/1/2019
Joe 2/2/2019
Joe 2/3/2019
Joe 3/1/2019
Joe 3/2/2019
Joe 3/3/2019
Joe 3/4/2019
Joe 3/5/2019
Joe 5/29/2019
Joe 5/30/2019
Joe 5/31/2019
Joe 6/1/2019
So the person above would have three episodes. One from 1/29-2/3, a second from 3/1-3/5, and a third from 5/29-6/1.
Thanks for your help.