Next 1st or 3rd Thursday, whichever comes first from a given date

[davidcom]

Hi all. Could someone please help me with a formula that will give me the next 1st or 3rd Thursday, whichever comes first, from a given date.

So for example if A1 = 4/2/24, the formula will return 4/4/24 (which is the earlier of the next 1st or 3rd Thursday)

If A1 = 4/11/24, the formula will return 4/18/24 (which is the 3rd Thursday of April, so the earlier of the next 1st or 3rd Thursday from 4/11/24)

And if A1 = 4/18/24, the formula would return 5/2/24 (which is the 1st Thursday of May, so the earlier of the next 1st or 3rd Thursday from 4/18/24)

Hopefully that makes sense!!

 

[davidcom]

@Tetra201 Thanks for pointing that out. I ran a test and can confirm that Post #4 does not give the correct result for a start date of 5/17/24. I assume it's due to the existence of 5 Thursdays in the month of May. I've changed the correct answer to Post #5, which seems to handle that instance.