How to insert current date in Excel

How to insert a static date in Excel

If we want to insert a static date value in Excel, we can use short cut key combination "Ctrl" + ";" (semi-colon).

Current date is inserted in Excel Cell as shown below.

How to insert dynamically changing date in Excel

Sometimes, you may need to insert dynamically changing dates in Excel. Dynamically changing dates update its value when a workbook is opened or recalculated.

To insert dynamically changing dates, you need to use Excel in-built function TODAY(). Below image shows how to use TODAY() function to insert dynamically changing dates in Excel.