Thanks, you're right. =A2-DAY(A2)+8-WEEKDAY(A2-DAY(A2)+1,1) gets it.
The logic, BTW: Get to the first day of the month-- a2-day(a2)+1 -- and
make an adjustment based on the weekday that the first of the month falls on
-- 7-weekday(a2-day(a2)+1,1) --. The adjustment adds 0 if the first is
Saturday, 1 on Friday, etc.
--Bruce

"Sandy Mann" wrote:

"bpeltzer" wrote in message
...
This seems to work: =a1-DAY(a1)+8-WEEKDAY(a1)

Are you sure? It doesn't seem to work for me for all dates but

=A2-DAY(A2)+8-WEEKDAY(A2-DAY(A2)+8,1)

seems to work OK

--
HTH

Sandy

with @tiscali.co.uk


"bpeltzer" wrote in message
...
This seems to work: =a1-DAY(a1)+8-WEEKDAY(a1)

"Barry" wrote:

I need a formula to find the first saturday in the month. i.e. cell a1
contains the date 2006 02 01, i need to know the first saturday in feb.