Find last Friday before last full week of the month

[daland1]

Hi,

I would need a formula that would find the last Friday before the last full week of a month (week with holidays are not considered full week). For example, in 2014, the formula would give the following dates for each month:
Jan 24, 2014
Feb 21, 2014
Mar 21, 2014
Apr 18, 2014
May 23, 2014
Jun 20, 2014
Jul 18, 2014
Aug 22. 2014
Sep 19, 2014
Oct 24, 2014
Nov 21, 2014
Dec 12, 2014

I found this thread but doesn't work http://www.mrexcel.com/forum/excel-questions/623932-get-date-last-friday-month.html

Hope someone can help!

Regards!

 

[daland1]

Thanks again! Yes, the holiday part I did understand. I'll try to make sense of the rest. The important thing is that it works.

Thanks!