Hi Rose

As Paul pointed out, you need to have a valid Excel date entered into
cell A1.
(If I type 20.02.2006 in cell A1, I also get a #VALUE error.)
I chose 20/02/2006 for next Monday's date. Do ensure it is not a Text
representation of the date.
Highlight cell A1, then FormatCellsNumberDate and highlight the 3rd
option down which shows 14/03/2001
Now enter 20/02/2006 in the cell (or, whatever the format is for your
regional settings)

To provide a result exactly the same as your second post to Paul, then
use the following formula

="Today is "&TEXT(A1,"dddd")&" "&TEXT(A1,"mmmm dd yyyy")
& CHAR(10)& "72 hour reports for " &UPPER(TEXT(A1+3,"dddd"))
&" "&TEXT(A1+3,"mmmm dd yyyy")&" are due today"

I have deliberately forced line breaks into the formula to allow it to
come out more clearly in this posting. The formula is really just one
continuous entry.

If you format the cell in which you post the formula with line wrap on,
then it will show on 2 lines as you requested, once you widen the
column.
FormatCellsAlignmentWrap text

--
Regards

Roger Govier


"Red Cross Rose" wrote in
message ...
Hi Roger, thanks for your reply!

I tried what you suggested, but I'm getting a #VALUE! error. Would
you
please break this down for me? Thank you for your patience with this
novice!
I obviously need a training class!

Rose


"Roger Govier" wrote:

Hi

With an Excel date in cell A1 which is a Monday e.g. 20/02/2006 then
="Today is "&TEXT(A1,"dddd")&", this report is due
"&TEXT(A1+3,"dddd")

--
Regards

Roger Govier


"Red Cross Rose" <Red Cross wrote in
message ...
How do I write a formula for Excel to read the value in a cell that
will be
Monday, Tuesday, Wednesday, etc. and respond with a corellating
day.

For example, "Today is Monday, this report is due Thursday". I
realize
Monday and Thursday will be represented in their own cells.

Thank you!