Ask Your Question

Calc automatic date on data entry

asked 2018-01-04 11:44:04 +0100

gtomorrow gravatar image

Hello all, Is it possible to automatically have a date entered in a cell when data in another cell is entered? Example: column A is awaiting data. If data is entered in say A4, I would like cell B4 to automatically enter the date of the data entry of cell A4, otherwise it would stay blank. Hope I was clear. Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-01-04 15:26:11 +0100

Lupp gravatar image

updated 2018-01-04 16:43:57 +0100

This is a question posted in slightly different ways again and again. I will noenetheless try a new answer.

To do this based on formulas would require to permit "Iterations" (circular references) and to misuse them for purposes they are not made for. Accepting some grave complcations we can get a very fragile solution for the task this way. In specific an error changing or deleting a date-time-stamp inadvertently cannot be made undone (by Ctrl+Z e.g.)

To do it with the help of custom code ("macros") is against the grain regarding what spreadsheets essentially are made for. It is, however, possible and much less fragile / more stable.

See this demo.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-04 11:44:04 +0100

Seen: 163 times

Last updated: Jan 04 '18