I wish to add the days of the week to a spreadsheet and skip every other
column. This can easily be done by manually entering it; however, as
the date changes with it's corresponding day from month to month there
is a need to change these every 2 weeks. For example, lets say that
the 1st of last month, October, fell on a Saturday. This month it
falls on a Tuesday. I wish to be able to open the spreadsheet, go to
the cell containing the day of the 1st (i.e. Sat) and change it to the
new day (Tue) with it resulting in all preceeding days changing
accordingly. Is this possible? How would one go about doing so?
Thanks for your time and effort in advance.

If this isn't clear I would be glad to send you the spreadsheet so that
you may take a look at it. The problem is quite obvious upon
examiniation.

Jonathan


--
BigBadTex
------------------------------------------------------------------------
BigBadTex's Profile: http://www.excelforum.com/member.php...o&userid=28476
View this thread: http://www.excelforum.com/showthread...hreadid=480857