Microsoft Excel – Get current date and time

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.

  1. 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′]

Leave a Reply