View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Conker10382
 
Posts: n/a
Default How do I revert cells to blank automatically on spacific days?

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?