Possible to get a time/date when a cell is written?

  • Thread starter Thread starter Twoflower
  • Start date Start date
T

Twoflower

Is it possible to get a date in a cell when another specific cell is "filled,
written, populated (not empty)"?
If yes, how?
 
Assume that if any value is entered in A1 cell then if you want to display
the today’s date in some other cell then use this formula.

=IF(A1<>"",TODAY(),"")

Instead of displaying today’s date if you want to display a specific date
then use the formula like this…

=IF(A1<>"","11-11-2009","")

The above will result text value. For getting the date values use the below

=IF(A1<>"",VALUE("11-11-2009"),"")

Or

=IF(A1<>"",--"11-11-2009","")

If this post helps, Click Yes!
 
A note or two (based on Ms-Exl-Learner's response)
If you use the TODAY() function, it returns just the date. If you need both
date and time, then use NOW() instead.

Problem with both of them is that they are volatile; that is they will
always report the current date/time each time the worksheet is recalculated.
To get a permanent record of the date/time that won't change over time you
will have to resort to a VBA solution.
 
Another way.............

Private Sub Worksheet_Change(ByVal Target As Range)
'Macro inserts date in Column B for change in Column A
ActiveCell.Select
If ActiveCell.Column = 1 Then 'Limits macro action to column A
If Not Selection Is Nothing Then
Application.Selection.Offset(0, 1).Value = Now
End If
Else
End If
End Sub

Vaya con Dios,
Chuck, CABGx3
 
Back
Top