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!