Forum Discussion
Automatically adding the date/time to a cell when another cell is updated
I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date/time stamp automatically updates in the cell right beneath the cell that was updated. I only need to have...
Haytham Amairah I want to be able to type a date in one cell and have it appear in another cell. It just two cells involved. How can I do this please?
Let's say you want to type a date in A2 on Sheet1 and you want it to appear in D3 on another sheet.
Format D3 the way you want, and enter the following formula in that cell:
=IF(Sheet1!A2="", "", Sheet1!A2)