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

What do you mean by "current" date? If you put =TODAY() in a cell, it will give you today's date. However, if you open the file in the future, that would automatically update to show the day that you opened it. I suspect you want a time-stamp (or static date) in those cells which does not change, and a formula can't give you that.

Hope this helps.

Pete

this seems to work. I am just wondering if the date will stay the same when i open the file on another day.

thanks

Also any advice on this problem???

I would like to count only when "yes" is entered into a cell and to do so on a 24 hour time table with the totals resetting to "0" when a new day starts.
Also would like to do the same in another total it for the month based on a date format of 11/15/13 from another cell.

1st: Hour formula:

B24 = formula
C29 = where "yes" or 'No" will be entered

count on a 24hour time table only when "yes" is entered.

2nd: Monthly Formula:

Q4 = Formula
B29 = Date (format is 11/15/13) however if that needs to change let me know.
C29 = where "yes" or 'No" will be entered

count when "yes" is entered for that particular month