On Mon, 17 Sep 2012 13:14:07 -0700 (PDT), Matthew Dyer wrote:

Try this:

=WORKDAY(DATE(YEAR(A1),MONTH(A1)+(DAY(WORKDAY(
DATE(YEAR(A1),MONTH(A1),DAY(A1)-1),1))15),16),-1)- Hide quoted text -

- Show quoted text -

That does the trick! thanks!!

Glad to help. Thanks for the feedback.