The DATE that i enter the DATA

Closed
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 18, 2015 at 12:56 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 19, 2015 at 12:52 PM
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
Related:

3 responses

ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Jan 20, 2015 at 11:20 PM
guys i need your helps
i will appreciate your answers
thanks.
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Feb 18, 2015 at 07:13 AM
im still waiting.
i really need to know is there any answer for this,
thanks for your replays.
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 19, 2015 at 12:52 PM
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.