I had previously asked this question "is there a way to have excel figure out
cetain dates for example the last saturday of every month for the next year?"
Answer:
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

Question 2:

Can you tell me how to use this formula by not dragging the date down and by
just using the systems time and date? What I was trying to do is set up a
time table starting with the date of December 24, 2005 and carrying through
using the second from last Saturday of each month. I got the formula to work
by dragging but I now want to know if you can help me with the formula by
using just the systems date and time?

Thanks

Bonnie Millward