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!