I'm not sure what mean by "selecting all the days of the month prior to the
first Friday." But for a given date in A1, you can calculate the first
Friday of the month as =A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),5,4,3,2,1,7,6).
The approach in that formula is to add an appropriate number of days to the
last day of the prior month.
HTH.
--Bruce

"PaulRMcHanJr" wrote:

I am trying to create a calendar with a "grace period" that ends on the first
friday of each month.
I can identify the first friday:
=AND(WEEKDAY(A1)=6,DAY(A1)<=7)
and the first week:
=AND(DAY(A1)<=7)
but can't get my mind around selecting all the days of the month prior to
the first friday...
Thanks,
Paul