Spreadsheet Date help

[TMAC130]

I have a spreadsheet that is printed in advance on any given day of the week.

The spreadsheet is a Sunday schedule.

Is there any way possible to have the date read something like:

Combined Week-End Schedule for Sunday 10-26-08?

Thank you in advance.

[reggie1000]

hi TMAC130,

try

Please Login or Register  to view this content.

this will give sundays date whenever the sheet is opened.

hope it helps reg

[TMAC130]

hi TMAC130,

try

Please Login or Register  to view this content.

this will give sundays date whenever the sheet is opened.

hope it helps reg

Thanks reg!

What if I needed it to read "Combined Schedule for Sunday, October 26, 2008?

Wil it know to always use the Sunday coming up?

How do I work that formula in?

I'm trying this formula and I can't seem to get it to work.

Thanks a million.

[DonkeyOte]

="Combined Schedule etc... for "&TEXT(TODAY()+(8-WEEKDAY(TODAY())),"dddd, mmmm dd, yyyy")