Inserting the current date in Excel different ways

The easiest and fastest way to enter into the cell current date or time - is to click the hotkey combination CTRL + «;» (today's date) and CTRL + SHIFT + «;» (the current time).

To use the TODAY () function is much better. It not only states but also automatically updates the information of the cell every day without user intervention.



How to put the current date in Excel

To insert the current date in Excel a person should use the function TODAY (). To do this, select the tool «FORMULAS»-«Date & Time»-«TODAY». This function has no arguments, so you can just type in a cell «=TODAY()» and press ENTER.

The current date in a cell:

TODAY.

If it is necessary to update automatically not only the current date, but the time in the cell, you’d better use the function «=NOW()».

NOW.

The current date and time in a cell.



The way to set the current date into the running title in Excel

Inserting the current date in Excel is implemented in several ways:

  1. By setting the parameters of the running title. The advantage of this method is that the current date and time are put on all the pages at once simultaneously.
  2. Using the function TODAY ().
  3. Using the hotkey combination CTRL +; - To set the current date and CTRL + SHIFT +; - To set the current time. The disadvantage in this process is that it will not be automatically updated to the current value of the cell parameters, the document is opened. But in some cases, lack of data is an advantage.
  4. With the help of VBA macros using the function code of the program: Date();Time();Now();.

The running title allows you to set the current date and time in the top or bottom of pages in the document to be output to the printer. In addition, the header allows us to enumerate all the pages of the document.

To make the current date in Excel and enumerate the pages with the help of the running page you should:

  1. Open the «PAGE LAYOUT»-«Page Setup» tab and select «Header/Footer».
  2. Page Setup.
  3. Click on the button to create «Custom Footer».
  4. Custom Footer.
  5. In the window that appears, click on the field «Center section:». On the panel, click the second button, «Insert Number of Pages». Then select the first button «Format Text» and set the format to display the page number (for example, bold and font size of 14 points).
  6. To set the current date and time, click on the field «Right section:» and then click «Insert Date» (if necessary, click on the «Insert Time»). Click OK in both dialog boxes. In these fields you can enter your text.
  7. Insert Time.
  8. Click OK, and look at the preliminary results display header. Below dropdown list «Footer:»
  9. Footer.
  10. «VIEW»-«Page Layout» menu, go to the preview of headers and footers. You can edit them there.
Edit them there.

Running titles allow us not only to set the date and page number. You can also add a space for the signature of the responsible person for the report. For example, the edit is now the lower left part of the page in the running titles:

Running titles.

Thus, it is possible to create documents with a comfortable place for signatures and seals on each page automatically.


en ru