Adding the date automatically when an input is inputted

alikishi

New Member
Joined
May 5, 2012
Messages
3
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Should you want to test the event macro

Code:
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
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top