|Subject:||How do I revert cells to blank automatically on spacific days?|
|Date:||Mon, 22 May 2006|
Does anybody know of a function, formual, or macro on Excel 2003 that I can
use so that my spreadsheet will automatically erase information in certain
cells on certain days? For example: On May 25th I will enter "YES" in cells
B5 and B6. I want cell B5 to automatically revert to a blank cell on June
5th and cell B6 to revert to a blank cell on June 11th. There aren't many
things that you can NOT do with Excel. Did I find one?