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

[excelteam777]

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

[Pete_UK]

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

[vlady]

usually vba is used on this type of problems (pasting the time stamp) in the cell


but for experiment try this one.

go to option->formulas -> check iteration.
in B29 creating a circular reference...
=IF(C29="","",IF(B29="",TODAY(),B29))

[excelteam777]

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

[alansidman]

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Intersect(Target, Range("C29:C39")) Is Nothing Then Exit Sub
    Range("B29:B39") = Date

End Sub

Put this in the worksheet event and not as a module.