Find next event in series

[Emeng]

Hi all

I would like to find a way to determine the next time an event occurs.

For example, if today is 12/11/2016 and using an initial start date of 13/11/2015 of an event that occurs every 6 weeks, to return 23/11/2016.

I’m trying to avoid a spreadsheet full of dates but will if it’s the best solution.

Any help much appreciated.

Thanks

Mark

 

[AVK]

If your start date in "A2" 13/11/2015 & next Date in "B2".
In "B2" enter formula as : =INT(A2+36)
In "A3" enter formula as : =B2+1
In "B3" enter formula as : =INT(A3+36)
...... & copy paste ..... so on ...... till you require

 

[p45cal]

For example, if today is 12/11/2016 and using an initial start date of 13/11/2015 of an event that occurs every 6 weeks, to return 23/11/2016.

If the start date is 13 Nov 2015, which is a Friday, and events occur every 6 weeks, all the events have to be on a Friday right? Your suggestion of returning 23 Nov 2016 which is a Wednesday sounds a bit awry.
Shouldn't that be Fri 25th Nov 2016?
Assuming it is, have your start date of Fri 13 Nov 2015 in A1, the following formula, in any other cell, should give you the first event after today:
=TODAY()+42-MOD((TODAY()-A1), 42)
I haven't tested with dates close to, or on, the event dates.
The 42 is the answer to the question of life, the universe and everything.
The 42s are 42 days = 6weeks x 7days.

If you want to use another date apart from today's date, have that date in another cell, say A2 and change the formula to:
=A2+42-MOD((A2-A1), 42)

I dare say the formula can be shortened.