formula for the third tuesday and the third thursday of each month

Which version of Excel are you using?

Try this example...
A1: ...any date....03-Sep-2014

This regular formula returns the 3rd occurrence of Tuesday in the month of that date

Please Login or Register  to view this content.

Where this string: "1011111" flags weekend days (beginning with Monday) with 1's and workdays with 0's.

and this formula returns the 3rd occurrenceo of Thursday in that month

Please Login or Register  to view this content.

Or...you could just use
C1: =B1+2

In that example,
B1 returns: 16-Sep-2014
C1 returns: 18-Sep-2014

Is that something you can work with?

Originally Posted by Ron Coderre

.....Or...you could just use
C1: =B1+2

That won't always work, though, Ron

For example In October 2014 the 3rd Tuesday is 21st October, the 3rd Thursday is 5 days earlier on 16th.....

Thanks for catching that, DLL...
I just assumed it would work..without testing :\