On Mon, 6 Feb 2006 13:32:13 -0800, "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.

If your date in A1 is always the first day of the month, then:

=A1+7-WEEKDAY(A1)

will give you the first Saturday of the month.

If the date in A1 can be any date in the month, the first Saturday of that
month will be given by:

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+1)


--ron