Excel: Today() Function – Auto-populating Today’s Date

Excel: Today() Function – Have you ever needed a particular cell, in Excel, to show Today’s date, every time you open it? Well, here is the formula to do that very thing:

Click in the cell that you want it to appear in and type the following code, including the parenthesis:


That’s it! Save your document and every day that you open it, it will show Today’s date.

Excel: Today() Function


Joe Austin

Joe Austin is the founder of Potentials Unleashed. He is currently an IT Professional Manager in the Financial Industry and has been using computers since 1978. While mostly self-taught, he is proficient in several computing areas, such as Programming , Web Development, most Microsoft Office programs, Internet Marketing, Spyware / Malware Removal and even 3D Animation & Modeling.

Click Here to Leave a Comment Below 0 comments
%d bloggers like this: