Hi John

If you made A1 hold the date then enter in B1
=$A$1+COLUMN()-2
Copy this across through C1:H1 and format cells Custom ddd
This will provide the days of the week, relative to the date entered in A1

Then each time you want to move things across, Insert a new column at B, and
copy C1 to B1
Record a macro as you do this, then run it whenever you need.

--
Regards
Roger Govier



"JohnM" wrote in message
...
my atble is set out
mon/tue/wed/thu/fri/sat/sun
date
then info for each day

When the date changes it becomes
tue/wed/thur/fri/sat/sun/mon
the dates move accordingly
the information for each day however has to be moved manually

--
JohnM


"Sean Timmons" wrote:

Not sure what data is being copied and pasted. If you want day of the
week to
change, you can also use =today() and format the cell as day.

"JohnM" wrote:

I have a table with field headings of days of the week and dates
In each column I enter numbers or text of what is happening on that day
I can get the headings to change automatically using =Today() in the
first
cell but then I have to manually Copy and Paste the rest of the data
Is there a way I can get this to happen as the date changes

Thanks for any help
--
JohnM