Get the next first or third Thursday

**SeniorSE** · 06-17-2014, 10:02 PM

What I want is a function that calculates the next first or third Thursday.

I currently have the following function in cell B4.

=IF(B3-DAY(B3)+1+7*1-WEEKDAY(B3-DAY(B3)+1-5)=B3,B3-DAY(B3)+1+7*3-WEEKDAY(B3-DAY(B3)+1-5),DATE(YEAR(B3),MONTH(B3)+1,DAY(B3))-DAY(B3)+1+7*1-WEEKDAY(DATE(YEAR(B3),MONTH(B3)+1,DAY(B3))-DAY(DATE(YEAR(B3),MONTH(B3)+1,DAY(B3)))+1-5))

The explanation is as follows: If the date in cell B3 is the first thursday of the month, make this cell the third thursday of the same month. Otherwise, make this field the first thursday of the next month.

Is there an easier way to do this??

Thanks!

**Tony Valko** · 06-17-2014, 10:30 PM

I think this does what you want.

B3 = some date

This formula entered in B4:

=IF(AND(INT((DAY(B3)+6)/7)=1,WEEKDAY(B3)=5),B3+14,EOMONTH(B3,0)+1+MOD(4-WEEKDAY(EOMONTH(B3,0)),7))

Format as Date

**SeniorSE** · 06-17-2014, 10:51 PM

Thank you! That worked.

At some point in time, I'll have to break down the formula to figure out what it's actually doing! LOL

Thanks, again!
Mark

**Tony Valko** · 06-18-2014, 08:46 AM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.