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

B1: =WORKDAY.INTL(EOMONTH(A1,-1),3,"1011111")

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

C1: =WORKDAY.INTL(EOMONTH(A1,-1),3,"1110111")

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 :\