How to date a digital image. Insert today's date in Excel in different ways How to put today's date in Excel

Setting the date and time on the computer is one of the simple settings. Basically, setting the time and date does not need constant tuning since it is enough to set the date and time once and forget about this setting 🙂 But there is a need to adjust it, for example, the cancellation of the transition to winter time in Russia.

In this article, I will show you step by step how to set the date and time in windows 7 on your computer, what other settings can be done with the time. How to turn off time synchronization, or how to change the display format of the date and time.

And since there are several ways to access setting the date and time, I will show you a simpler and more complex one.

And so, let's get started.

Adjust date and time via system tray

First, let's look at a simple way to set up the date and time:

Step 1. On the taskbar, in the lower right corner, click once with the left mouse button on the date and time. In the window that appears, click Change date and time, as shown in the figure:

To change the date and time on your computer, your Account must have administrator rights, otherwise you will not be able to make changes. How to find out if your account has administrator rights.

Step 3. In the window that opens, setting the time and date, use the arrows to select the desired month, year and date. And under the clock, set the time you want.

After selecting the correct date and time, press OK. That's it, you have set the date and time.

Advanced date and time settings on the computer

Another time and date setting you can make is to change your time zone by choosing your time zone where you are. If you need to configure the time zone, then in the date and time tab, left-click on change the time zone:

In the window that appears Select time zone from the drop-down menu, select your time zone, or that you need.

With the adoption of the law on the abolition of the transition of Russia to winter time, in the automatic transition to winter time and back to windows, the meaning is lost, uncheck the Automatic transition to winter time and back, if something changes then put it back 🙂

If you have installed an update from Microsoft, then the time zone setting for you will look like this:

Another date and time setting you can make is to change the time sync run and change the sync server from the list provided.

Step 1. Go to the Internet time tab and click on the change settings button (Administrator rights required):

Step 2. If you have unchecked the Synchronize with an Internet time server checkbox, then check it and select any server you like from the list, as in the picture:

After setting, click on the OK button!

Another way to access the date and time settings

Now let's look at another way to access the time and date settings, this is through the control panel. So, let's begin.

Another useful thing for websites is an insert current date... There are dozens of examples of date scripts on the Internet, but many of them, in my opinion, are heavy and, therefore, ugly. Meanwhile, using standard means JavaScript, it is very easy to insert a date on a website page. I use it very often! In the picture (screenshot from the current site) estate "Fairy Tale" !

Here is the entire date script:

In my opinion, it could not be easier, it is quite beautiful and understandable. If you have no desire to study the construction of this script, then simply paste it anywhere in the HTML page and you will get the following inscription:

Another option is more advanced


! Today

It looks like this:

Today

In general, no skills are required, just stupidly insert the code and everything is ok!

More details:

So, we start by assigning a date value to a variable d, then create arrays ( Array) for the days of the week ( day) and months ( month), indicating them in the necessary grammatical form: case, number, capital letter if the word is at the beginning of a date, etc. The last line script - actually printing the date ( document.write). Here you set what and in what sequence you will display the current date in the string. The components are separated from each other by the sign + ... To enter a space, use the construction " " , and to enter the letter g (year) - the construction " G."

As you can see from the script, getting data about the current time is performed by the element get... This method provides the following information:

  • getDate ()- returns a number from 1 to 31 representing the day of the month;
  • getDay ()- returns the day of the week as an integer from 0 (Sunday) to 6 (Saturday);
  • getMonth ()- returns the number of the month of the year;
  • getFullYear ()- returns the year. To use simply getYear (), then the current year minus 1900 will be displayed;
  • get Hours ()- returns the hour of the day;
  • getMinutes ()- returns minutes as a number from 0 to 59;
  • getSeconds ()- returns the number of seconds from 0 to 59.

Paste directly Java-script inside the site page is not always convenient. Better to put the script description at the top of the page between tags and set a variable that we will call as needed in the text. Let's call it TODAY and define the date display form in it similarly to the above. The script will look like this:

To display the date, call the script in the right place in the HTML code of the page using the following command:

If your site contains many pages on which you want to display the date, then it is more convenient to highlight Java-script for displaying the date in separate file, for example, data.js... In practice, this is a page consisting of the first of the described scripts, that is, with the line document.write(see above). It should be located in the same directory as the main page, and called at the date display place as follows:

Don't forget to check that the file data.js had the same encoding as the main document, otherwise the date will be displayed with wonderful hooks, squares and other tweaks.

Comment. It should be borne in mind that the described script displays the date set on the user's computer, which does not always correspond to the real current time. If you need to show the exact time, then you need to use a PHP script that will show the time on the server.

The simplest and quick way to enter the current date or time into a cell - this is to press the combination of hot keys CTRL + ";" (current date) and CTRL + SHIFT + ";" (current time).

It is much more efficient to use the TODAY () function. After all, it not only sets, but also automatically updates the cell value every day without user intervention.

How to put the current date in Excel

To insert the current date in Excel, use the TODAY () function. To do this, select the tool "Formulas" - "Date and Time" - "TODAY". This function has no arguments, so you can just type in the cell: "= TODAY ()" and press Enter.

Current date in cell:

If it is necessary for the cell to automatically update the value of not only the current date, but also the time, then it is better to use the "= TDATA ()" function.

The current date and time in the cell.



How to set current date in Excel on headers and footers

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

  1. By setting the parameters of the headers and footers. The advantage of this method is that the current date and time are stamped on all pages at once.
  2. Using the TODAY () function.
  3. Using the hotkey combination CTRL +; - to set the current date and CTRL + SHIFT +; - to set the current time. The disadvantage is in this way the cell value will not be automatically updated to the current values ​​when opening the document. But in some cases, data disadvantage is an advantage.
  4. Using VBA macros using the following functions in the program code: Date (); Time (); Now ().

Headers and footers allow you to set the current date and time at the top or bottom of the pages of the document that will be output to the printer. In addition, the header and footer allows us to number all the pages of the document.

To make the current date in Excel and pagination using headers and footers, do this:


Headers and footers allow us to do more than just set dates and pagination. You can also add a place for the signature of the person responsible for the report. For example, let's edit now the bottom left of the page in the header and footer area.

I think we should stop the New Year's break and start writing articles. Since everyone has a lot of photos after a series of holidays, let's start with this topic. So, the task is to put the date and time of the picture on the photo. Moreover, we have a thousand photographs taken on different days at different times. Of course, for one photo it's very easy, just start Paint. But what about a thousand photographs? A small and free for non-commercial use program called XnView (http://www.xnview.com/en/xnview/#downloads) will help us here. And then we act according to the instructions:

1) Launch and go to the folder where the necessary photos are. We select all those that we need to mark with the date (in order to select everything, you can use the universal combination Ctrl + A):

2) Right-click on the selected photos and select "Batch Processing". Or press the combination Ctrl + U.

3) In the window that opens, in the "Output" section, specify the folder for saving copies of images with the changes made to them. You can change the format of the images if you want.

4) Go to the "Transformation" tab:

5) Choose "Image" → "Add Text" double click or select and press the "Add" button. The item should appear on the right side of the window:

6) Next, there are several options. Ideal, of course, if your camera writes Exif to a photo file. Fortunately, most modern cameras do this.
Therefore, in the "Parameters" section, press the arrow to the right and select "Exif-Camera" → "Shooting date".
But there are all sorts of cases and not all cameras can do this, so if it doesn't work for you, try the following options in order:
- Options → "Creation date"
- Options → “IPTC location” → “Creation date”.

After selecting the programs, it will write the variables to the parameters item in the following form:

This means that at the output we will receive an inscription in the format: 2014-01-09_19-45-31 ... Which in my opinion is not very pretty, but fortunately, this parameter can be changed as you like. Using the following variables:
Y - year in four-digit format (2014);
y - year in two-digit format (14);
B - month name (January);
b - abbreviation of the name of the month (Jan);
m - month as a number (01);
d - day as a number (09);
A - Day of the week (Thursday);
a is the abbreviation of the day of the week (Thu).

And, knowing these values, I change the parameter for myself and get the following:

Which will give the output the date in the format 09.01.14 19:54. All that remains is to choose the position, font, color and, if desired, the background for the inscription. You can also save the script to use it later.

class = "eliadunit">

Sometimes the task arises to put the date of the photo on the photo. This question is solved quite simply: any simple graphics editor and (after looking in the properties of the image) the date of the snapshot is set. An absolutely different task when you need to put a date on several dozen, hundreds of photographs. In this case, comes to our aid software entitled

Then go from the "General" tab to the "Transformations" tab. Expand the "Image" menu => select "Add Text":

class = "eliadunit">

Add the creation date to the "Parameters" (you can select not only it, the functions of the XnView program are extensive):

Below we select the location of the date, color and font. After setting, press "Run", after which the operation of applying the date on the photo will take place.

Finally, it is worth giving a little advice: given that after pressing the "Run" button, your photos will be overwritten, it is recommended (and suddenly the result does not satisfy you) to do backup images before processing them in

  • Troubleshoot an error when starting Office 2010 on XP
  • How do I upgrade from Internet Explorer 8 to version 11 for Windows 7?
Fitting © 2021 Tech Look - Gadgets. Android device. Antiviruses. Security. Graphics. Internet. Mobile devices