Subject: Adding a cell comment with a value from a diferent cell and on a
different sheet

Is there a way to add a comment to a cell which the comment contains the
value from a different cell.

Scenario:

I have cells which have the days of the week abbreviated (Su, Mon, Tues,
etc) These cells have a narrow width just enough for the abbreviation. I
would like to add a comment to that cell which the comment would be: Sunday,
August 27th, 2006

Screenshot:
http://img172.imageshack.us/img172/1...ethoursmu6.jpg

The 09/02/06 is the week ending date (Saturday for week 1). The value (week
ending date) can change depending on what start date the user indicates on
another sheet.

What it would look like:
http://img101.imageshack.us/img101/8...thours2fc2.jpg

Thanks in advance for any help!!!

ADK