You'd want a VBA Worksheet Change event, if the date is not there by Worksheet Function. See the following:
http://www.cpearson.com/excel/Events.aspxHowever, if it's there by function, e.g., Today(), which is volatile, you might want to consider the Calculate event.