first saturday in a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
bpeltzer said:
This seems to work: =a1-DAY(a1)+8-WEEKDAY(a1)
Click to expand...
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
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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
 
Thanks very much ron.

Ron Rosenfeld said:
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
Click to expand...
 
Back
Top