In this quick tutorial we will be going to add the current date and time as a cell within an Excel spreadsheet, the date and time will update each time a change to the spreadsheet is made or each time it is opened.
To do this carry out the following steps.
- Select the cell and enter in the following “=NOW()”
By default the date and time will be in the following format ‘dd/mm/yyyy hh:mm’ although can be changed if needed.
the_ad id=’545′]