Hello,
I have the following Excel workbook (please see attached Example.xlsx), as it has commented the expected output.
I calculate the dates on column D as dates of column B [R-1] - 1 (day).
The problem arises when it reaches the last date within the same car model(as it gets its date from the below car model when it shouldn't).
So I was thinking of applying the If condition or so on the last date within the same entry (same car model), like within the same region on column A
Thus the last date on the last entry on the Ending Date column within the same car model should be the Initial Date from that same row + 1 (day).
Or would this be easier to achieve with a for loop in VBA?
Any advice/help would be appreciated!
Thank you!
Gordon
Bookmarks