software

2nd-The next spreadsheet I would like to display the quot;week of 2-26-06quot; and
have that change as the day does.

3rd-The last spreadsheet I have the days of the week listed from left to
right with the date under them. Is there anyway that I could have those
dates change along with the new week?

Any help would be greatly appreciated!

Thanks,

Henry

*This is the answer I received from the last time. I can't seem to get it to
work. For
#2 I don't know if I'm entering it correctly or not. Am I suppose to be
entering it just as it looks?

#3 I got this to work! ***But how do I do the same thing if I start the
week on Monday? I don't have sunday on the spreadsheet.

2nd: =quot;week of quot; amp; TEXT(TODAY()-WEEKDAY(TODAY()) 1,quot;m-d-yyquot;)
3rd: put =TODAY()-WEEKDAY(TODAY()) 1 under Sunday. If that is cell B2, then
the next column to the right would be =b2 1 (change b2 to reference whatever
cell Sunday's date is in). Copy that formula to the right another five
columns.
Hi Henry

2nd =quot;Week of quot;amp;TEXT(TODAY()-WEEKDAY(TODAY(),2),quot;mm-dd-yyquot;)

3rd Assuming your first day is Sunday, and is in cell C1 then in
cell C2
=TODAY()-WEEKDAY(TODAY(),2)
in cell D2
=C2 1
and copy across through cells E2:I2
--
Regards

Roger Govierquot;Henryquot; gt; wrote in message
...
gt; 2nd-The next spreadsheet I would like to display the quot;week of 2-26-06quot;
gt; and
gt; have that change as the day does.
gt;
gt; 3rd-The last spreadsheet I have the days of the week listed from left
gt; to
gt; right with the date under them. Is there anyway that I could have
gt; those
gt; dates change along with the new week?
gt;
gt; Any help would be greatly appreciated!
gt;
gt; Thanks,
gt;
gt; Henry
gt;
gt; *This is the answer I received from the last time. I can't seem to get
gt; it to
gt; work. For
gt; #2 I don't know if I'm entering it correctly or not. Am I suppose to
gt; be
gt; entering it just as it looks?
gt;
gt; #3 I got this to work! ***But how do I do the same thing if I start
gt; the
gt; week on Monday? I don't have sunday on the spreadsheet.
gt;
gt; 2nd: =quot;week of quot; amp; TEXT(TODAY()-WEEKDAY(TODAY()) 1,quot;m-d-yyquot;)
gt; 3rd: put =TODAY()-WEEKDAY(TODAY()) 1 under Sunday. If that is cell B2,
gt; then
gt; the next column to the right would be =b2 1 (change b2 to reference
gt; whatever
gt; cell Sunday's date is in). Copy that formula to the right another five
gt; columns.
gt;
gt;