Hi all

I have a list of codes and dates that I am trying to count depending on the group number. Within each group is a date. Each time the first group number appears I want a (.) to signify that its the first one in the group, the following lines should add up the amount of days between the previous date within the group. I hope I explained that well enough to understand. I am including an example so that you have an idea of what I am trying to accomplish. Thanks in advance for any and all assistance.

Attached Files

Example.xlsx (9.8 KB, 8 views)