close
Does anyone have an idea of how to accomplish this?
=DATE(YEAR(A1),MONTH(A1),1 7*3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-6))
with any date in A1 will return the third Friday of the month
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
quot;KJPquot; gt; wrote in message
...
gt; Does anyone have an idea of how to accomplish this?
全站熱搜