List of 3rd Wednesdays of each month
<p>I'm trying to find the formula to automatically generate the Third Wednesday of Each month.I searched and found this:  </p>

<pre><code>=LOOKUP(A3,DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},22)-WEEKDAY(DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},4)))
</code></pre>

<p>Where my first Wednesday is in A3. However this formula only give the results for 3, 6, 9 and 12 months. Would anyone please give me a formula to get all year 12 months and keep going to the following year if I drag down.</p>