Date not updating in excel worksheet
So if you want to have both date and timestamp, you can use two different cells, one for date and one for the timestamp.
In the above method using shortcuts, the date and timestamp inserted are static values and don't update with the change in date and time.
With the above formula, once the timestamp is inserted, it doesn't update when you change the contents of the adjacent cell.
If you want the timestamp to update every time the adjacent cell in Column A is updated, use the below formula: This formula uses the CELL function to get the reference of the last edited cell, and if it's the same as the one to the left of it, it updates the timestamp.
This can be done using the keyboard shortcuts (as shown above in the tutorial). With shortcuts, you'll have to manually insert the date and timestamp in Excel.
To automatically insert the timestamp, there is a smart technique using circular references (thanks to Chandoo for this wonderful technique).
You may also see a prompt as shown below: This happens as you are using the cell reference A3 in the calculation that is happening in A3.Note: When you enable iterative calculations in workbook once, it will be active until you turn it off.To turn it off, you need to go to Excel Options and uncheck the ‘Enable iterative calculation' option.To do this: Note that this formula is volatile and would recalculate every time there is a change in the workbook.If you want the date and timestamp together in a cell, you can use the NOW function.
Note that this formula is volatile and would recalculate every time there is a change in the workbook.