Thread: Need to find each day prior to first friday, monthly
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Need to find each day prior to first friday, monthly
On Wed, 13 Dec 2006 16:51:00 -0800, 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


=AND(A1(A1-DAY(A1)),
A1<(A1-DAY(A1)+9-WEEKDAY(A1-DAY(A1)+2)))


--ron
Reply With QuoteReply With Quote