On Mon, 10 Oct 2005 14:49:03 -0700, "Bonniem"
wrote:
is there a way to have excel figure out cetain dates for example the last
saturday of every month for the next year?
If you put this formula in A1, and copy/drag down, it will give you the date of
the last Saturday in every month starting with Jan 2006:
=DATE(2006,ROW()+1,1)-WEEKDAY(DATE(2006,ROW()+1,1))
The portion ROW()+1 denotes the month, and will change automatically as you
drag the date down. So if you start, for example, in A5, you would change that
to ROW()-4
--ron
|