Hi Paul,

To find the 1st Friday of next month, try:
=INT(DATE(YEAR(A1),MONTH(A1)+1,1)/7+0)*7+6
Change the ‘+1’ to get another month, the ‘+0’ to get another week & the ‘+6’ to get another day.

To find out whether the date in A1 is within this month's grace period, try:
=A1<=INT(DATE(YEAR(A1),MONTH(A1)+0,1)/7+0)*7+6

Cheers

--
macropod
[MVP - Microsoft Word]


"PaulRMcHanJr" wrote in message ...
| 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