Basic overview:
I am parsing the column, if it is a date, I convert the date to a date corresponding with a Wednesday (same day, or next Wednesday). Then I get the value from row under the date. If the Wednesday date is the same as previous, I keep adding the number value. If it is different, I store the number value in a cell, reset the count, and repeat. For this data, I should be getting:
8/26/2015 7
9/2/2015 6
9/9/2015 3
But what I actually get is:
8/26/2015 1
9/2/2015 7
9/9/2015 8
WB is attached below. I know I need to set prevDate the first time, but I couldn't get it to work
Any assistance to get it working and/or suggestion to make the code more efficient will be appreciated!
Attachment 426518
Bookmarks