How to automatically update the data in a report after entering a date in Excle

2. If you insert the time, only keep the year, month and day, you can enter the formula "=today()" in the cell, this formula will automatically update the date according to the time you use this **. As shown in Fig

3. If the inserted time needs to keep the year, month, day, hour and minute, you need to enter the formula "=now()" so that the content displayed in the cell is the information of the year, month, day, hour and minute using **. As shown in Fig

4. If you need cells to display yesterday, tomorrow, and the day after tomorrow, add or subtract them after the original formula, for example: yesterday is =today()-1", tomorrow is "=today()+1"; The current time minus half a day is "=now(), and adding six hours is "=now()+".

5. And so on, it can be flexibly changed and used according to needs.

First of all, the merged cells of sheet4 should be split, that is, abc should be split into aaabbbccc, otherwise it cannot be calculated.

Then enter :: in cell F6 of sheet3

lookup(1,0/((sheet4!$e$4:$m$4=$e6)*(sheet4!

e$5:$m$5=f$5)),offset(indirect(address(sumproduct((sheet4!$d$6:

d$23=$d$6)*row(sheet4!$d$6:$d$23)),sumproduct((sheet4!

d$6:$d$23=$d$6)*column(sheet4!$d$6:

d$23)),1,1),1), and then pull the formula down to the left. It took a lot of time, looking.

Selected Data - Right Click - Cell Format.

In the dialog box that pops up, click "Delete" by Value-Custom-Click

Then save and it's OK.

To make the time inserted in Excel update automatically, you can use the formula "=today()"."to achieve it.

1. Open the Excel** that needs to be operated.

2. Enter the formula "=today()" in **"Press the Enter key on your keyboard.

3. You can see that the year, month and day of the day have appeared in **, and the date will change to the date of the day when you open ** the next day.

4. If you want to specify the time to every minute and second, you can enter "=now()" in **

5. You can see that the time has become more specific, and when you open ** again, the time will change accordingly.

In Excel, you can follow the steps below to automatically update the date.

1. First, create an excel** that needs to automatically update the date.

2. Then select the cell you want to update the date automatically, click the formula in the toolbar, and select the insert function.

3. A dialog box pops up, select "today" in the function, and then click OK.

4. Click OK to pop up a dialog box, and then click OK.

5. Finally, it can be changed to today's date, and the date can be automatically updated with the computer time.

This can be achieved with the today() formula.

1. Take Excel2010 version as an example, first select the cell you want to insert the date, then click the "Formula" option at the top of the page, and then click the "Insert Function" option under the formula menu bar;

2. Select the category in the pop-up box, find "Date & Time", and click;

3. Then find the today function in the following selection function, click it, this function refers to the current date in the return date format, and then click OK below;

4. A box will pop up to indicate that the function returns the current date, which will be automatically updated with the change of date, click "OK" below;

5. You will see that the time is the time of the day, and when it comes to the 29th, it will be automatically updated to 2018 12 29.

Enter the date in Excel** and watch it for the feast to update automatically every day

The materials we need to prepare for dissensitization are: computer, excel**.

1. First of all, we open the required excel sheet and take the branch, click the cell that needs to be updated automatically, and then click to open the "formula" in the main menu bar.

2. Then we click to open "Date & Time" in the pop-up window and select "Today".

3. Then we click "OK" in the pop-up window.