December 4, 2020

How to Insert current date in a cell in excel

In our excel worksheet we need to insert the current date in cell A2.

Ctrl+; 
  • See below the current date has been inserted in cell A2.

  • Now if you need to change the format of the date, you can right click on the cell and go to ‘Format Cells’.

  • Select the Date format as required from the available formats in Date category in Format Cells pane.

Leave a Reply

Your email address will not be published. Required fields are marked *