No I have =today() in the first date box and then the cell number + 1 in the
rest - as the date changes so everything moves across
--
JohnM


"Bernard Liengme" wrote:

Please explain meaning of "date and day MOVES to left"
Are you using conditionally formatting to highlight the cell with the
current date?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JohnM" wrote in message
...
Can you help

I have a table (part shown below) the Date and Day moves automaticaly to
left at midnight - is it possible to get the rest of the data to move as
well

25-Nov 26-Nov 27-Nov 28-Nov
Sun Mon Tue Wed
07:00 07:00
TBA
on off on off on off on off
1 1
1 1

1 1

1 1
1 1
1 1
1 1

--
JohnM