Formula Needed to auto populate current date when text entered into a cell

I simply need to auto populate the current date in the format 11/15/13 when any text is entered into another cell.

B29:B39 = current date to be populated (formula)

C29:39 = any text