I live in a world where production data is not evaluated on a calendar monthly basis. Instead, our "month" runs from the Wednesday after the third Tuesday of one month to the third Tuesday of the next month. How can I write a formula in Crystal to display the appropriate month-end date of a given date. For example, the parameter date is December 22, 2005. The corresponding month-end date should be January 17, 2006.

Any help would be greatly appreciated!