Adding the date automatically when an input is inputted

[alikishi]

Without using Macros and VBA, is there a way for the date to automatically come out when a cell already has something inside it? For example:

Let's say I want A2 to show today's date if some information is inputted in cell A1.

=if(not(isblank(A1)),today(),"") will not work because it will always show the current date and not the date when information was inputted in cell A1.

Thank you everyone!

 

[James006]

Hi,

Indeed ... with =IF(A1<>"",TODAY(),"")

You have to manually take care of the cell format AND copy paste values ...

Much easier to have an event macro ...

 

[Fluff]

If you want a static date, then you will to do it manually, or with VBA.
Whilst i believe it is possible to do it with a formula, you would have to turn on iterative calculation.

 

[James006]

Should you want to test the event macro

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <> 1 Then Exit Sub
With Target
    .Offset(0, 1) = Date
    If .Value = "" Then .Offset(0, 1).ClearContents
End With
End Sub

Hope this will help