With a date in cell A1 (to pick the year and month) the below formula will do.

=DATE(YEAR(A1),MONTH(A1),1+7*3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-6))
(format the formula cell to date format)


If this post helps click Yes
---------------
Jacob Skaria


"thomas donino" wrote:

Is there a function that will return, for example, the third friday of the
month? Or does one need to create it in vba?
Thank you