Auto dating excel 2016
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.
Note that as soon as I enter something in cells in column A, a timestamp appears in the adjacent cell in column B.
However, if I change a value anywhere else, nothing happens. Now when you enter anything in column A, a time stamp would automatically appear in column B in the cell adjacent to it.
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).
While this shortcut does not insert the timestamp, you can use the following shortcut to do this: Control Shift : This would instantly insert the current time in the cell.So, if you enter 8/8/11 and use the fill handle to create a date series, you end up with 8/8/11, 8/9/11, 8/10/11, and so on.There's a lot of built-in flexibility to the fill handle, if you know how to access it.Now, when circular reference error happens, there is a non-ending loop that starts and would have led to a stalled Excel program.
But the smart folks in Excel development team made sure that when a circular reference is found, it is not calculated and the non-ending loop disaster is averted.
To do this: Note that this formula is volatile and would recalculate every time there is a change in the workbook.