Date stamp if specific string in column A

I would like to enter various information in column A and if I enter the string "complete" in any of the cells in column A, then a date stamp will be displayed in the same row in column B. Please see example attached.


Here's a similar question that the code could be tweaked from.

http://www.excelforum.com/excel-work...ate-stamp.html

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”