Hi guys,

I am trying to get the 3rd wednesday of each quarter or select months such as March / June / Sep / Dec
The thread below works great showing the 3rd wed for every month.
http://www.excelforum.com/excel-gene...-of-month.html

But what I was hoping would be to
1. show the date of the next 3rd Wednesday for the end of the current quarter
2. The moment the today's date becomes the 3rd Wed, the date shows the subsequent 3rd Wednesday for the next quarter.

Appreciate any input thanks!