Hi,
I have tried to figure this out but got stuck.
I have 2 sets of dates. The set in column "A" includes all the dates. The set in column "H" contains a summary of the dates.
When the dates skip in column "H" ex. 8/13 to 8/16, the formula needs to refer to Column "A" and sum 8/13+8/14/+8/15.
The biggest jump in the spreadsheet is a total of 6 days.
I have attached a sample spreadsheet with details. The yellow highlighted cells is where the formula needs to go.
Thanks.
Bookmarks