problem change date based on change item

[Hasson]

hi guys

I search for way when I add item in cells into column A will add the date (today) in cells into column B ,and when I open the file tomorrow should be the old date has ever added . should not change based on date(today) . just if change the item in column A then should add date(today).

for instance if add in A2 = asd-100 then the date in B2 will be 6/27/2022 and if I open the file tommorrow keep the date 6/27/2022 not 6/28/2022

and if I change A2= asd-21 then automatically should add date(today).
I hope is clear .

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
The script will run when you enter any value in column 1
And the Date put in column 2 will never change.

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  6/27/2022  7:43:17 AM  EDT
If Target.Column = 1 Then
Target.Offset(, 1).Value = Date
End If
End Sub

 

[Hasson]

thanks for taht and sorry I don't mentioned should be by formula
I have this formula

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

but doesn't work waht I look for

 

[Fluff]

You cannot do what you want with a formula.

 

[Hasson]

@Fluff even if use multiple helper cells ?

 

[Fluff]

Nope, not if you want the date to change if A2 changes.

 

[Hasson]

@Fluff I no know if you understand my request . just if I change in A2 should be date(today) and if I open the file should keeping the date as yesterday without change to date(today). As long as the cell A2 is not changed then keep the old date without change it . is that impossible ?

 

[Fluff]

Do you want the date to change if the value in A2 changes?

 

[Hasson]

Do you want the date to change if the value in A2 changes?

yes should be

 

[Fluff]

In that case you cannot use a formula.