Subscribe to our YouTube Channel for more Videos

TODAY function to insert today’s date in Excel

This post explains you how to insert today’s date in your Excel worksheet using the TODAY() function.

If you are looking at inserting today’s date in a cell , one of the best options that you have is to use the TODAY function in Excel.

How to insert today’s date in Excel Worksheet ?

To insert today’s date in Excel , just enter the below formula in a cell


TODAY function updates itself everytime a worksheet is opened or changed in Excel as long as the automatic recalculation is turned on in your Workbook.

Additionally , you can format the value returned by the TODAY() function using the built-in date format.

How to insert today’s date in Excel using Shortcut ?

Select the cell where you want to insert today’s date and use the key board shortcut Ctrl + ; , you should see today’s date in the cell.

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.