Thread: [Solved] Help with a formula
View Single Post
 
Old 07-12-2020, 02:46 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default Help with a formula

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
File Type: xlsx Example.xlsx (9.8 KB, 6 views)
Reply With Quote