Find the last Saturday of the month for any date:

=EOMONTH(a1,0)-CHOOSE(WEEKDAY(EOMONTH(a1,0)),1,2,3,4,5,6,0)
Cell (A!)
5/11/07 05/31/07 =eomonth(a1,0)
5 =WEEKDAY(eomonth(a1,0))
CHOOSE(WEEKDAY(A1,0),1,2,3,4,5,6,0)
5/26/2007 = The Last Saturday

=WEEKDAY(eomonth(a1,0))
Sunday(1) through Saturday(7)
Sunday is 1 -1 = a Saturday
Mon is a 2 -2 = a Saturday
Tue is a 3 -3 = a Saturday
Wed is a 4 -4 = a Saturday
Thu is a 5 -5 = a Saturday
Fri is a 6 -6 = a Saturday
Sat is a 7 -0 = a Saturday


"Chuck M" wrote:

Hi,

I can't get my head around the calculation necessary to find the date of the
last Saturday in any given month. Any help will be greatly appreciated!

--
Thanks.
Chuck M.