Calculate next occurrence of specific weekday

[juleska]

Hi all,

I'm trying to find a function that will help me take a date from one column and, using that, calculate the next occurrence of a Thursday, then show that in a date format.

Can anyone help?

Thanks!

 

[VoG]

Try

=A1+CHOOSE(WEEKDAY(A1),4,3,2,1,0,6,5)

 

[grizle]

Or, if you don't want the same date returning for a Thursday,

=A1+CHOOSE(WEEKDAY(A1),4,3,2,1,7,6,5)

 

[juleska]

Try

=A1+CHOOSE(WEEKDAY(A1),4,3,2,1,0,6,5)

Thanks! That worked perfectly!! Can you explain to me what that function is doing so I understand the logic?

 

[VoG]

Assume A1 contains today's date.

Weekday returns the day of the week as a number. Today (Friday) = 6.


CHOOSE selects values from a list - 1 gets the first value and so on.

So as today's week day is 6 it chooses the 6th item in the list, which also equals 6.

It then adds 6 to today's date giving next Thursday's date.