The DATE that i enter the DATA

Closed
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,
is that possible to know the date that i enter the data in a cell.
for example i enter the data in cell B1 today and i want this date in C1 cell
(i dont wanna use track changes option)
thank you for your answers

3 replies

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
guys i need your helps
i will appreciate your answers
thanks.
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
im still waiting.
i really need to know is there any answer for this,
thanks for your replays.
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
I found this after a very quick Google:

https://stackoverflow.com/questions/9311973/automatic-date-update-in-a-cell-when-another-cells-value-changes-as-calculated

Following the instructions in there.
I've tried it and it works.

It uses the Workbook Custom Properties to store and compare any changes.