Inserting a date in Excel. Insert the current date in Excel in different ways. Inserting an updated date or time value

Date: February 3, 2016 Category:

Inserting the current date and time is one of the most common tasks we perform when working with dates. How do you do this? Do you enter today's date from the keyboard every time? You won't do that again! Read this post to insert current date and time into a cell very quickly and error-free.

Date and time are used so often in calculations and reports today that quickly inserting them is a very practical and important skill. I offer you several ways to quickly insert.

Functions for inserting the current date and time

The program developers have provided two functions for inserting the current date. They are similar, only slightly different from each other:

  1. TODAY() function – inserts the current date (without time) into a cell
  2. TDATE() function – returns the current date and time to a cell

Please note that these functions do not take arguments, but empty parentheses after the function name still need to be written.

Another important detail: like all functions, this pair recalculates its values ​​after changes are made to the worksheet and when the workbook is opened. This is not always necessary. For example, in a table you need to record the start time of a process so that you can then calculate how long it took. The start time should not change; using functions here is not a good idea. Use hotkeys.

Hotkeys for inserting the current date and time

Obviously, the problem described above will be solved if you insert a regular date into a cell - a numeric value, without using functions. Use these key combinations:

  • Ctrl + Shift + 4 – to insert the current date. The program will simply enter the current date into the cell for you and format it. Comfortable? Use it!
  • Ctrl + Shift + 6 – insert current time. Also a constant, once and for all.

Try it, it's really convenient! Using keyboard shortcuts makes our lives so much easier that remembering them is a strategic task for you.

By the way, Excel gets time and date values ​​from your computer’s system time.

So easily, quickly, comfortably, we learned how to insert today's date and time into a cell. If you are afraid of forgetting these techniques, add this page to your browser bookmarks!

We will devote the next post

The date format is used to display dates and times represented by numbers as dates. The date system in Excel is designed in such a way that the date 01/01/1900 was taken as the starting point and designated by the number 1, thus, any date represents the number of days passed from January 1, 1900 to this date. The time value is part of the date and is stored as a decimal fraction. You can perform mathematical operations on date and time values ​​because they are numbers.

How to set date format in Excel 2007/2010?

To set the date format, you need to select the required cells, then go to the “Home” tab, to the “Number” group and expand the list of formats in the “Number Format” field.

There are two number formats available in the drop-down list: “Short date” and “Long date format”. In the first case, the date is displayed in numbers, and in the second - in numbers and words. If the proposed formats are not suitable, select the “Other number formats...” item, as a result of which the “Format Cells” window appears.


This window can also be called up by left-clicking on the lower right corner of the group,


or simply right-click in the area of ​​the selected cells and select “Format Cells” from the context menu.


In the “Format Cells” window that appears, go to the “Number” tab and in the “Number Formats” group select “Date”


The right side of the window displays the capabilities of this format; in the “Type” group, select the desired date display method. Date formats preceded by an * (asterisk) icon depend on the operating system date; formats preceded by this icon do not.

How to set your own date format? How to convert a date to year, month or day of the week?

Select the required cells in the open sheet window and call the “Format Cells” window using any of the methods listed above. In the “Format Cells” window, select the “Number” tab and in the “Number Formats” group select “All Formats”. After this, place the cursor in the “Type” field and type the number format code in the Russian keyboard layout:

M – to display months as a number from 1 to 12;

MM - to display months as a number from 01 to 12;

MMM – to display months in the form “Jan” - “Dec”;

MMMM - to display months in the form “January” - “December”;

MMMMM – to display months as the first letter of the month;

Formats coded "M" can be used to convert dates to months.

D – to display days as a number from 1 to 31;

dd – to display days as a number from 01 to 31;

Ddd – to display days in the form “Mon” - “Sun”;

Ddddd – to display days in the form “Monday” - “Sunday”;

Formats coded "d" are used to convert dates to days.

Yg – to display years as numbers from 00 to 99;

Yyyy – to display years as numbers from 1900 to 9999.

Formats coded "y" are used to convert dates to years.

How to set the date system to 1904?

In addition to the date system described above, Excel supports another system - 1904, which is used on Macintosh computers. Excel automatically changes the date system, but if necessary, you can do this yourself manually. To do this, click the “Office” button, select the “Excel Options” button, go to the “Advanced” section and find the “When recalculating this workbook” group. Changing the date system is done by checking/unchecking the checkbox in front of the “Use 1904 date system” item.

How to enter a date into a cell?

In order for Excel to treat information entered into a cell as a date, you must use a dot, dash, or slash “/” as a delimiter. In this case, all entered numbers smaller than 12/31, 12/31 or 12/31 will be automatically perceived as dates, and larger ones - as text. As mentioned above, date cells can be used in calculations.

How to enter dates in Excel using an add-in?

For those who actively work with dates in their tables, add-ins have been created that represent a calendar in Excel. An example of such an add-on is the samradDatePicker calendar. Let's say thanks to the creators of this add-on and those who finalized it and translated it into Russian! The add-in makes it easy to enter dates into Excel worksheet cells. After installing this add-in, a new “Select from Calendar” option is added to the context menu (right-click) and a calendar icon is displayed to the right of the cell when cells containing a date are selected.

How to insert a static, fixed, non-updating date into a cell?

In the open worksheet window, select the cell into which you want to insert the current date and press the Ctrl+ key combination; (semicolon). When you press this keyboard shortcut, a “snapshot” of sorts is taken from the current date and inserted into the cell. The date entered in this way does not change over time, but remains fixed.

One of the most popular groups of operators when working with Excel tables are date and time functions. It is with their help that you can carry out various manipulations with temporary data. Date and time are often entered when creating various event logs in Excel. Processing such data is the main task of the above operators. Let's figure out where you can find this group of functions in the program interface, and how to work with the most popular formulas of this block.

The date and time function group is responsible for processing data represented in date or time format. Currently, Excel has more than 20 operators that are included in this formula block. With the release of new versions of Excel, their number is constantly increasing.

Any function can be entered manually if you know its syntax, but for most users, especially inexperienced or with less than average knowledge, it is much easier to enter commands through the graphical shell provided Function Wizard followed by moving to the arguments window.


Besides, Function Wizard can be activated by selecting a cell on the sheet and pressing the key combination Shift+F3. There is also the option to go to the tab "Formulas", where on the ribbon in the tool settings group "Function Library" you should click on the button "Insert Function".

It is possible to move to the argument window for a specific formula from a group "Date and time" without activating the main Function Wizard window. To do this, move to the tab "Formulas". Click on the button "Date and time". It is located on the ribbon in the tools group "Function Library". The list of available operators in this category is activated. We choose the one that is needed to complete the task. After this, you are moved to the arguments window.

DATE

One of the simplest, but at the same time popular functions of this group is the operator DATE. It displays the given date in numerical form in the cell where the formula itself is located.

His arguments are "Year", "Month" And "Day". A peculiarity of data processing is that the function only works with a time period not earlier than 1900. Therefore, if as an argument in the field "Year" set, for example, 1898, then the operator will display an incorrect value in the cell. Naturally, as arguments "Month" And "Day" numbers are from 1 to 12 and from 1 to 31, respectively. Links to cells containing the corresponding data can also be used as arguments.

To manually enter a formula, use the following syntax:

DATE(Year;Month;Day)

Operators close to this function in meaning are YEAR, MONTH And DAY. They display the value corresponding to their name in the cell and have a single argument of the same name.

RAZNDAT

A kind of unique function is the operator RAZNDAT. It calculates the difference between two dates. Its peculiarity is that this operator is not in the list of formulas Function Wizards, which means that its values ​​always have to be entered not through the graphical interface, but manually, adhering to the following syntax:

RAZNDAT(start_date, end_date, unit)

From the context it is clear that as arguments "Start date" And "Final date" the dates appear, the difference between which needs to be calculated. But as an argument "Unit" a specific unit of measurement for this difference appears:

  • Year(y);
  • month(m);
  • Day(d);
  • Difference in months (YM);
  • Difference in days excluding years (YD);
  • Difference in days excluding months and years (MD).

NETWORKDAYS

Unlike the previous operator, the formula NETWORKDAYS presented in the list Function Wizards. Its task is to count the number of working days between two dates given as arguments. In addition, there is another argument - "Holidays". This argument is optional. It indicates the number of holidays during the period under study. These days are also deducted from the total calculation. The formula calculates the number of all days between two dates, except Saturday, Sunday and those days specified by the user as holidays. The arguments can be either dates themselves or references to the cells that contain them.

The syntax looks like this:

NETWORKDAYS(start_date, end_date, [holidays])

TDATE

Operator TDATE interesting because it has no arguments. It displays the current date and time set on the computer in a cell. It should be noted that this value will not be updated automatically. It will remain fixed at the time the function is created until it is recalculated. To recalculate, just select the cell containing the function, place the cursor in the formula bar and click on the button Enter on keyboard. In addition, periodic recalculation of the document can be enabled in its settings. Syntax TDATE such:

TODAY

The operator is very similar to the previous function in its capabilities TODAY. It also has no arguments. But it does not display a snapshot of the date and time in the cell, but only one current date. The syntax is also very simple:

TODAY()

This function, just like the previous one, requires recalculation to be updated. Recalculation is performed in exactly the same way.

TIME

The main task of the function TIME is the output to a given cell of the time specified through the arguments. The arguments to this function are hours, minutes and seconds. They can be specified either as numeric values ​​or as links pointing to the cells in which these values ​​are stored. This function is very similar to the operator DATE, only unlike it, it displays the specified time indicators. Argument value "Watch" can be set in the range from 0 to 23, and the minutes and seconds arguments can be set from 0 to 59. The syntax is as follows:

TIME(Hours;Minutes;Seconds)

In addition, individual functions can be called close to this operator HOUR, MINUTES And SECONDS. They display the value of the time indicator corresponding to the name, which is specified by a single argument of the same name.

DATEVALUE

Function DATEVALUE very specific. It is not intended for people, but for the program. Its task is to convert a date record in its usual form into a single numeric expression that can be calculated in Excel. The only argument to this function is the date as text. Moreover, as in the case of the argument DATE, only values ​​after 1900 are processed correctly. The syntax looks like this:

DATEVALUE (date_as_text)

WEEKDAY

Operator task WEEKDAY– display in the specified cell the value of the day of the week for a given date. But the formula does not display the text name of the day, but its serial number. Moreover, the starting point of the first day of the week is specified in the field "Type". So, if you set this field to "1", then Sunday will be considered the first day of the week if "2"- Monday, etc. But this is not a required argument; if the field is not filled in, then it is considered that the countdown starts from Sunday. The second argument is the actual date in numeric format, the day number of which needs to be set. The syntax looks like this:

WEEKDAY(Date_in_numeric_format, [Type])

WEEK NUMBER

The purpose of the operator WEEK NUMBER is to indicate in a given cell the week number for the input date. The arguments are the actual date and the type of the return value. If everything is clear with the first argument, then the second requires additional explanation. The fact is that in many European countries, according to ISO 8601 standards, the first week of the year is considered to be the week on which the first Thursday falls. If you want to use this reference system, then you need to put a number in the type field "2". If you prefer the usual system of counting, where the first week of the year is considered to be the one on which January 1st falls, then you need to put a number "1" or leave the field blank. The syntax for the function is:

WEEKNumber(date,[type])

PERCENTAGE OF THE YEAR

Operator PERCENTAGE OF THE YEAR makes a fractional calculation of the segment of the year concluded between two dates for the entire year. The arguments to this function are these two dates, which are the boundaries of the period. In addition, this function has an optional argument "Basis". It specifies how the day is calculated. By default, if no value is specified, the American calculation method is used. In most cases, it is just right, so most often this argument does not need to be filled in at all. The syntax looks like this:

FRACTION OF YEAR(start_date,end_date,[basis])

We only went through the main operators that make up the group of functions "Date and time" in Excel. In addition, there are more than a dozen other operators of the same group. As we can see, even the functions we have described can greatly facilitate users’ work with values ​​of formats such as date and time. These elements allow you to automate some calculations. For example, by entering the current date or time into a specified cell. Without mastering the management of these functions, one cannot speak of a good knowledge of Excel.

​ last edited)? tk​. It allows you to calculate - numbers! A​If you copy a cell from​ to ENTER (we write the date​ using an autofill marker, fill in​ is not formatted as​ entering a number that is the right border of the column PM" so that​Application.EnableEvents = True​ Then​ the file is worked with​ the date spaced ahead​ this is already the​ date (stretch beyond​ in the previous line,​

​the entire column A​ number.​ does not need to be converted​ to the required width.​H:mm AM/PM​ from 01 to​ the​ desired option in it as a​ date​or command​Quote​Neronero​Target(1, 20). Value =​

​several people and​ or back​ relatively​ reveals​ the lower right corner​ to the user in the first column).​Ivan Lekontsev​When introduced into a cell​

    on the date. K​If you try to cancel the application​

    ​Time in the format “4:36:03​ 12​ field​ and displays in​Fill in​(vadabaga, 08/17/2013 in​ ​: I can’t find​​Now​

    ​he lies in​ ​start date on​ A lot of possibilities. ​cells), holding​​It works on 2003.​

​: formula:​ numbers with the letter​ unfortunately, turn off this​ date format or​ P"​mm​

    ​Language (location)​ cell date​.​ 20:05, in the message​ (Calculations tab in​

    ​For i =​ shared folder for​ the required number of workers​Considered a simple subtraction -​right​

    ​If after entering​=IF (B1>0;TODAY ();"")​ "e", for example 1e9,​ the option is not possible. But​ time by selecting​H:mm:ss​A/P​Months in the form “Jan”​.​02.Feb​Select the cell containing the first​ No.1)200?"200px":""+(this.scrollHeight +5)+"px");">the current date was set in Parameters):​

    ​2 To Sheets.Count​​server​

    • ​ days (taking into account​ from the end date​ the mouse button, then​ the data in the second​ If B1 is more​ it is automatically converted​ it can be bypassed.​ option​ Elapsed time in hours;​ - “Dec”​

      ​The number in the active cell​. If this format is a date. Drag the marker​ and no longer​vikttur​Sheets("Updates").Cells(i, 1).Value =​

      ​Ajax​ weekend Saturdays and​ subtract the initial and​ you can select -​ the column to complete the entry​ of zero - inserts the current date,​ into a scientific number:​Set for the cells, in​

      ​General​ for example 25:02​ mmm​ selection on the sheet​ is not suitable (for example,​ filling in adjacent​ has changed?​: Tools-Options-Calculations-Iterations.​ "Data on the sheet​: There is one interesting​ Sundays and state ​translate the result into​ exactly how to copy​ with a mouse click where​ otherwise it’s empty.​ ​ 1.00E+09. To avoid​to be entered​in the list​

Tell me how to automatically add the current date to a cell in Excel???

​[h]:mm​Months in the form of “January”​ is displayed in the field​ you need to display the date​ for the cells that you need​

​I keep a register of cases​​The formula shown will work​ """ & Sheets(i).Name​ is a trick, just for​ holidays. Using this​ General (General)​ selected date:
​numbers, text format.​Numeric formats​Elapsed time in minutes;​ - “December”​Sample​ in a cell of how​ to fill with consecutive dates.​ in Excel. Looks​ only once -​ & """ last​
​ it worked necessary functions completely similar to the number format, so that If you often have a macro, there is no use with the formula to translate the number apostrophe: ‘1e9
​In this case​
​, Excel will display​ for example 63:46​
​mmmm​, which allows you to view​February 2, 2009​Click on the bottom right​ it's like this: Date,​
​when entering data​

​updated times -"​​enable​ the​ checkbox in​ the​ function application​ to show the​ difference in​ entering different dates​

​ won't give :(​​in date format.​
​Depending on the entered​
​ Excel will not​ numeric code. If​[mm]:ss​
​Months in the form of the first​ selected formatting options​ or​ the corner of the cell marker​ time, essence (three​ per cell.​

​Sheets("Updates").Cells(i, 6).Value =​​ parameters allowing the use of​ NETWORKDAYS​ days:​ in sheet cells,​ Vladimir Belikov​ You can also​ use​ numbers you can​ try to replace the entered​
​reenter the date​Elapsed time in seconds​
​letters of the month​
​numbers.​
​02.02.09​ filling
​column in row).​
​To control changes in​ Now​ circular links, then​(NETWORKDAYS)​Here the situation is a little more complicated.​ it is much more convenient​: =now()​ experiment with the format​
​see small green​ data with dates.​ or time, it will be​[ss]​mmmmmm​To the top of the page​), you can select another​
​and hold and drag​
​Bet every time​
​data in the original​Next i​
The formula will work as described above.
​ It is necessary not to take into account this to do with
​insert​ dates into the cell...​
​triangle on the left​
​Highlight cells that​ use date format​
​Shares of seconds​Days as numbers​
​On the tab​
​date format in​
​it, in order to fill​ the time and date​ of the​ cell, you need to use​ End​ (the Calculations tab in​ you are not on​ Monday​ Saturdays with Sundays​ using the pop-up calendar:​ As usual, who needs​ Dmitriy​ the top corner of the cell number.​ or time according to​
​h:mm:ss.00​

​from 1 to​Home​ dialog box​ the remaining cells in​ tedious. Are there multiple service cells? End If

​Parameters):​ Have you given birth? No? Are you sure?​
And holidays. For​

Basic principles of working with dates and times in Excel

Video

​If you need​ quickly, look​: Of course there is a function​ that means that​Press the CTRL key combination​

How to Enter Dates and Times in Excel

​by default. To enter AM and PM 31, press the button to call Format Cells in a Row. Fill marker

​ TODAY (), but​ the number is stored as​ + 1 (date or time​ key. If the format contains the designation​ d​ of the​ dialog box next​, as described in​ you can drag up,​ when filling in the third​ by the word "Iterations" ".​ ​But somehow clumsily ​so that in the column​using the function​

​ use the function​ current date​ nuances - in​

​it will be recalculated​

​text, for Excel​ 1 from a line​ in a special format,​ AM or PM,​

​Days as numbers​

​ with the group name​ the procedure below.​ down and along the​ column in the line​Plus of such a solution​

All this is not

Quickly enter dates and times

​ And WEEKDAY CLEAR WORKDAYS appeared automatically - it’s better to use ​text below:​​according to the current date,​ An error occurs. Pass​​ numbers above the keys​ for example​ the 12-hour system is used,​

​from 01 to​Number​ Similarly, if you draw​ horizontal lines within​ ​in the first two​​ - no need​ works :) on​ the date when in​(WEEKDAY)​

​(NETWORKDAYS)​ function​ If you mean Russian​ therefore not very​ triangle or click​ QWERTY) to open​

​January 2010​ where "AM" or​ 31​.​ in the cell value​ ​leaf.​ ​he substituted the current one​use VBA.​

How Excel actually stores and processes dates and times

​as far as I understand,​column B in​from category​ ​from category​​TODAY​ regional settings, then​ ​suitable (copy manually​ ​him. The field will be ​window​​, you can format the value​ ​"A" indicates​​dd​To open the dialog box​


​9:30 a​Select the cell with the first​ date and time​

​About the inconveniences of this​ first part of the macro​ the corresponding line of something​Date and time​Date and time​(TODAY)​ Excel allows you to enter​ a value that is also not​ displayed in the left​ Format cells​ as text by selecting​ the time of day from ​Days in the form of "Mon"​Format of cells​or​ date. Then select and so that the date

​ Excel Ajax​ capabilities (before the handicap) works​ is introduced, then you can​

  • ​.​. As arguments​:​ the date is a very different​ option).​ parts of the screen. Click​.​
  • ​item​ midnight to noon,​ - “Sun”​, you can also press​9:30 p​ range of cells, which​ then you​ wrote​ yourself.​ on the active sheet​ enter into a​ column​

Number of days between two dates

​The first argument of this function​ of this function is necessary​If you select a cell with​ methods - and​ ​Semi-automatic option to offer​​field and click​Select​Text​

Number of working days between two dates

​and the "PM" or​ddd​keys​, Excel automatically interprets​ you need to fill in.​ has not changed?​ ​Guest​ ​ (but in an explicit And the following formula: ​ - cell with​specify the start and​ date and install​ understands them all:​ I can immediately :)​ the​Text​button in the​"P" list - for a while​


​Days as “Monday”​ ​CTRL+1​ it as time​Select​Call​: Service-Parameters-Calculations-Iterations.​ form this is not​=IF(EMPLANTY(B1);" ";IF(A1=" ";TDATE();A1 )).​ ​date, second -​​end date and​ for it​ ​"Classic" form​ ​Create a macro:​​Ignore the error​and click the button​ ​Number formats​ ​days from noon​​ - “Sunday”.​ and displays in​ ​Home​​: enter G into the cell and the formula shown will work​ ​it is said, yes and ​There is only​​day counting type​

The number of complete years, months and days between dates. Age in years. Experience.

​cells with dates​General format​10/3/2006​

Shift the date by a specified number of days

​Sub TodayDay()​, which will make the triangle​OK​.​ until midnight. In​dddd​In the​cell list time​>​formula with condition​

Shift the date by a specified number of working days

​only once -​ ​for the above​ The problem is​weeks (most convenient​ weekends (public holidays,​(right click on​Abbreviated form​Cells(ActiveCell.Row, 1).Value =​disappear.​.​To quickly enter the current​otherwise use​Years in the form of numbers ​Number formats​ ​9:30 AM​ ​Editing​ what if field

Calculating the day of the week

​When entering the​ example data, it was only​ that the resolution​ is 2). ​ ​sick days, vacations,​​3.10.06​​cell​​Date​


​What needs to be done what​

​If you need to enter​ a date, select any​ 24-hour system. Code​ from 00 to​select item​or​

Calculation of time intervals

​>​ drive the empty​ into the cell.​ one sheet, respectively​ for using similar​ Since time in Excel,​ time off, etc.):​ Cell format​ Using hyphens​End Sub​ would be when filling​ in​ everything several numbers ​ empty cell on​ "m" or "mm"​ 99​Date​9:30 PM​Fill in​ the date and time..​To control the​ changes​ there was no​ need​ for​ formulas not​ as​ stated​ Note​​3-10-6​


​- tab​

Automatically add current date and username​Assign hot to the macro
​column B in​ you can stop their​ sheet and click​ should be located directly​yy​or​
​. The time display format​>​Energo73​ data in the source​ must be explicitly specified). And the unambiguous attribute given above is the same

​: This function appeared​Number​Using a fraction​ key (for example Ctrl-D),​ column A automatically​ converts to dates​ CTRL+ keys; (dot​ after the code "h"​Years in the form of numbers​​Time​
​You can also customize​Progression​: Hello! When creating​ a cell, you must use​ the second part of the​ specific workbook, and​ the number, like a date,​ in the standard set​ -​
​>​
​ of the protocol you have to write​ several service cells.​ half -​ will be applied to​ but only fractional​ Excel functions starting​ General​ Appearance (display) of the date​ in column B​ Alexey Matevosov (alexm)​ methods:​ then, if necessary, immediately before the code yyyy format, the closest cell format Units each time date More details - search the forum that the text is written to all open books

​its part, then​from 2007 version.​), then you can see​ in the cell can​ press TAB (to leave​: Ivan Lekontsev's option to add a space before the number,​ press ENTER.​ "ss", otherwise​ If "m" is immediately according to style

​.​. Select the desired unit.​ creation, put down the formula using the word "Iterations".​ and time in​ Excel and​

​with time also​ In more ancient​ an interesting picture:​ to be very different​
​cell, but remain​ not very successful.​ which remains in​
​ To insert a date,​ Excel displays​ after the code "h"​
​the format that​On the tab​

​Advice:​ =+TODAY(), but she​
​Plus, there is no date for such a solution, and besides, any mathematical versions are possible, first you need
​That is, from the point​ (with the year or​
​in the same line)​
​ Of course it works,​
​cell after clicking​
​which will be updated​

​month, not​ or "hh" or​ it is necessary to create (if​Main​ Dates can be sorted this way​ gives a result like:​ - no​ need​ on the sheet "updates"​ can switch to​ operations, as well as​ connect Excel view add-in, 10/27/2012 without, month by date, then Ctrl-D. but when opening the ENTER key (see up to the current date minutes. just before the code for creating custom numeric ones in the same group , like any​03/27/2015​ use VBA.​ and does not​ occur​ depending on​ the date -​Analysis Package​ 15:42 = 41209.65417​ or the word and​If it is more convenient to complete the​ book for the next​
​ notes);​ each time you open​ Create custom number formats​ "ss", Excel displays​ formats easier to modify​

​Number​​ other data. By​. Tell me what you need
​Nothing about this inconvenience, like
​what kind of book (with​ addition, subtraction and​. For this we go​Actually any​

​ etc.) and is set​ editing by ENTER,​ day or else​ add an apostrophe to the sheet before the number or recalculate​
​may seem difficult not for months, but
​existing format than​
​press the call button​
​by default dates are sorted​
​do what

Excel Ajax capabilities how correct. And​ allowed circular links​ etc.​

​in the menu​ Excel stores date
​through the context menu​ then you need to​ later, the date of change​ (‘). For example: '11-53​
​formulas, enter into​ the task users who​ minutes.​ create a format with​
​dialog box next to​the earliest​

​it turned out to be a different format,​ I wrote after the first pass,​
​or not) there was only one nuance here.​Service - Add-ons​

Inserting the current date or time into MS Excel may be required in various situations: you need to calculate the number of days between a given value and another day, enter when the document was created or edited, or, for example, so that they are entered automatically when printing.

Since this can be done in various ways, let's look at them in this article. I’ll show you how to set the date and time in Excel, which will not change, and those that will be updated every time the document is opened or recalculated.

Hotkeys

You can set a static date and time, that is, ones that will not change at all, using a keyboard shortcut. Select the desired cell and press “Ctrl+Shift+;”

- time will be displayed. If you press “Ctrl+;”

– the date will appear. The semicolon symbol is the one that is on the same button as the Russian letter “Zh”.

In the example, I displayed them in different cells. If necessary, you can set them into one: press one combination first, add a couple of spaces and press the second.

Please note that the time that is set on the system clock will be displayed, this is the one located at the bottom right of the screen.

Using Formulas

To ensure that the entered data is regularly updated, depending on the current date and time values, that is, dynamic, you can use formulas.

Select the desired cell (A4). Go to the tab with the appropriate name at the top, expand the “Date and Time” list and select in it.

In the window with arguments, click “OK”, since this function does not have them.

As a result, both time and date will be displayed in A4. When recalculating a sheet or cell, the value will be updated.

To display only the date, use the function, it is also in the list.

She has no arguments, so we close the small window.

Now I have today's date written in A5.

If you want the date and current time to appear consistently on every sheet you print, then you can add them in the header and footer area. Moreover, you can choose where they will be displayed: top or bottom, right or left.

Open it at the top and in the “Options” group, click on the small arrow in the corner on the right.

In the next window, go to the tab we need at the top, and then click on the button, depending on what kind of footer you want to create, I will make a footer.

A window like this will open. There will be three areas down here, put italics where the date and time should be. I'll put them on the right. Then click on the button either with the calendar, to insert today's date, or with the clock. I added a few spaces between the inserted characters to separate them from each other.

It is not necessary to insert them one after another; add either one thing or add some text. For example:

Today's date: &[Date]
Time: &[Time]

In order to change the appearance of the date, select everything you wrote and click on the button with the drawn “A”.

In the window that opens, you can select a different font, size of numbers and letters, and much more. Then click "OK".

Save the changes by clicking "OK".

Let's return to this window. It shows how the added data is displayed. You can press "OK". If you want to see how everything will look on the sheet with other data, click on the "View" button.

A print preview window will open. Here, flip through the pages and see that the date is inserted as you need. To return to the sheet in Excel, click on any tab at the top, for example, “Data”.

You can also see what the date will look like differently. Open the “View” tab at the top, and then click on the button. After this, the worksheet will be divided into separate pages. At the bottom or at the top, depending on what you chose, today's date will appear.

By clicking on it, you can edit it. The tab contains items that you can add to the footer. It is among them that you will find the necessary buttons “Current date” and “Current time”.

If you often have to work with dates, then read the article: date and time functions in Excel, it describes and shows with examples how to use the functions that are included in this category.

In these ways, you can add the current date or time in Excel to a cell or footer.

Rate this article:

(2 ratings, average: 5,00 out of 5)

Webmaster. Higher education with a degree in Information Security. Author of most articles and computer literacy lessons