LearnFast.Ninja

Adding current date in Excel 2010

How to display the current date and time on a worksheet, and have that value updated each time you open the worksheet.

Step 1: Click the Formulas tab > Insert Function.


Step 2: Select Date & Time.


Step 3: Select NOW function > OK > OK.




Result:


Tags

excel

date