"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.