The DATE that i enter the DATA

Closed
ArashMan Posts 41 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

3 replies

ArashMan Posts 41 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.
0
ArashMan Posts 41 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.
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
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.
0