Bob, thanks for your reply, but I'm afraid I'm too much of a novice to make
your instructions work for the calculation.

"Bob Phillips" wrote:

="Report due on "&TEXT(A1,"dddd")

where A1 is your date.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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!