Date functions
 

is there a way to have excel figure out cetain dates for example the last
saturday of every month for the next year?

http://www.cpearson.com/excel/distribdates.htm

Niek Otten

"Bonniem" wrote in message
...
is there a way to have excel figure out cetain dates for example the last
saturday of every month for the next year?

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