How Excel displays today's date

How Excel displays today's date:

Show today's date Step 1: Open the Excel2007 file interface.

Show today's Date Step 2: Select the cell, enter the formula in the cell =today ()

Show today's date Step 3: Then click any of the remaining cells or press ENTER to display the day's date in the cell of the TODAY function.

Show today's Date Step 4: Enter formulas in the remaining cells =today ()-1 and =today () +1 display the date of yesterday or tomorrow respectively, if change 1 is 2 or 3 is from the day forward to the back of 1 2 3 days.

Show today's date Step 5: With the formula cell, right-click to format the cell.

Show today's Date Step 6: Select the number-date in the pop-up dialog box, select the date format as shown in the following illustration, or you can display the format of the day of the week.

Show today's date Step 7: After clicking OK, the date in the formatted cell has changed.

Word Tutorial

Excel Tutorials

PowerPoint Tutorials