Maybe something like...

=TEXT(A1+7,"d") & CHAR(10) & " this is some event text"


blueboy wrote:

Well, I got it to work, but in reality I am looking for something that does
not do the full date, but rather just the day's date, like:

__________________________
| 6 | 7 | 8 | 9 | 10 | etc.

Do you know how I could get that?

"Debra Dalgleish" wrote:

What's in cell A1? Is it a date?

If you used my variation of the formula, make sure you include all the
double quote marks:

=TEXT(A1+7,"dd-mmm-yyyy") & CHAR(10) & " this is some event text"

blueboy wrote:
I just copied and pasted the text in your message, but it didn't work. Yes,
it is English.

"Dave Peterson" wrote:


What was the formula you used?

Do you use an English version of excel?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



--

Dave Peterson