If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible to get a time/date when a cell is written?
Is it possible to get a date in a cell when another specific cell is "filled,
written, populated (not empty)"? If yes, how? |
#2
|
|||
|
|||
Possible to get a time/date when a cell is written?
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! -------------------- (Ms-Exl-Learner) -------------------- "Twoflower" wrote: Is it possible to get a date in a cell when another specific cell is "filled, written, populated (not empty)"? If yes, how? |
#3
|
|||
|
|||
Possible to get a time/date when a cell is written?
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. "Twoflower" wrote: Is it possible to get a date in a cell when another specific cell is "filled, written, populated (not empty)"? If yes, how? |
#4
|
|||
|
|||
Possible to get a time/date when a cell is written?
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 "Twoflower" wrote: Is it possible to get a date in a cell when another specific cell is "filled, written, populated (not empty)"? If yes, how? |
Thread Tools | |
Display Modes | |
|
|