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 .
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 .