Displaying the date

[Guest]

1st-I would like to display the date, and have it change as the day does. It
is a spreadsheet that I use for scheduling everyday.

2nd-The next spreadsheet I would like to display the "week of 2-26-06" 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

 

[Guest]

1st: =today(), entered in a cell, will always show the current date
2nd: ="week of " & TEXT(TODAY()-WEEKDAY(TODAY())+1,"m-d-yy")
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.