Ok i figured out how to do a time stamp, but know i am trying to format the
rule that JE McGimpsey provides in his website. So that the date stamp does
not appear in next cell but in another cell. Below is a link with the example
of the rule.

http://www.mcgimpsey.com/excel/timestamp.html

Thanks