A good alternative (although manual) is to use keyboard shortcuts CTRL + or CTRL + : to insert current date and time in the active cell.

Thus we cannot use NOW () as a time stamp. Just paste the below code within the ThisWorkbook Microsoft Excel Objects folder within the Visual Basic Editor (make sure you double-click ThisWorkbook to properly open its code page). The only problem with it is that, when you press F9 or recalculate formulas, the now () will be changed to reflect latest date and time. Hence, when we want to add hours to a date, we divide the hours by 24. Since there are 24 hours in a day, one hour is expressed as 1/24. Excel has a unique way of storing time, wherein one day has the value 1. There is also a way you can incorporate VBA code to automatically refresh the file’s stock data every time you open up your workbook. Column E shows the result when we add date and time using cell references. If you want to refresh all linked data types and all data connections that may be in the workbook (including queries, other data connections, and PivotTables), click Data > Refresh All or press Ctrl+Alt+F5. That will refresh the cell you selected, plus any other cells that have that same data type. To refresh the data, right-click a cell with the linked data type and click Data Type > Refresh. That way, if the data changes online, you can update it by refreshing it in Excel. Once you convert text to a linked data type, an external data connection is established in the workbook. This is because they refer to an online data source. The Stocks and Geography data types are considered linked data types.

How do you insert current date in excel