I have a situation where a variable event happening on a particular date identifies another date offset by the variation. so I created a dynamic table looking like this
1 Calculated Start Date 1
2 Next Date in the Sequence 2
3 The Date after that 3
4 Some other Date in the future 4
5 Ad Infinitum 5
The dates are not consecutive but are always formulated Tuesday>Friday>Tuesday…
The table is interpreted as two ranges;
Range A = COL 1 & 2
Range B = COL 2 & 3
I VLOOKUP() Range B on Date and the number is returned
I add my variable to the number and VLOOKUP Range A to return a forward date
Is there a better way of doing it?
The assignment of Tuesday>Friday is not an issue, I know how to define the next date in the range(s) I’m just trying to ascertain the final date for a variable number of intervening events which can be anything from 7 to perhaps 16.
The first date is also variable according to when the last “event” occurred and that is already included in the automatic generation of the first date in the table.
EDIT:
I thought I’d create an extract from the working sheet to demonstrate and as I started to amend the sources and referrals to simplify the operation of the demo sheet, I realised that I was “overthinking” the first VLOOKUP() - It would always be 1 - I only need to increment whatever was the latest recorded event by the variable number of additional events
As Simple as This 
Find Next Event.ods (17.5 KB)
Fixed it Myself
1 Like