The days will be manually typed in each morning. It's just a basic 2-line
entry that will say
Today is MONDAY (or whatever that day is) February 20 2006
72 hour reports for THURSDAY February 23 2006 are due today
We can manually enter the day/date on the first line, but I want excel to
automatically calculate the day/date of the reports that are due on the
second line.

Thanks Paul!

"paul" wrote:

we need more info.How are the days "stored" Are they typed monday tuesday etc
or do they represent a real excel date formatted as dddd.?

--
paul
remove nospam for email addy!



"Red Cross Rose" wrote:

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!