Entry time Age Year Age Month 2001 12 30 How to set formulas

The age format cannot be calculated by applying excel formulas, and the date format needs to be modified to 2001-12-30, as follows:

1. Open Excel**, click Find & Select in the menu bar, and click the Replace button.

2. Enter it in the pop-up dialog box. , replace with -in the box, and click the Replace All button.

3. Click OK in the replacement success window that appears, and you can see that the date format has been replaced.

4. Enter the formula =datedif(b2,today(),) in a blank cell"y")&"years"&((datedif(b2,today(),"m"))-datedif(b2,today(),"y")*12)&"month"and press Enter.

You can find the length of service.

5. The mouse prevents the lower right of the calculated seniority cell from pulling to the cell that needs to calculate the seniority to apply the seniority of other personnel.

1.First of all, your date format must be one approved by Microsoft Excel: i.e. the year, month, and day are separated by " " or "-", not ""Separation. You need to put all of themReplace with " " or -".

2.Assuming that B2 is the entry time and C2 is the cut-off time, the formula for calculating the seniority (years) is: DateDif(B2,C2,"y"), the formula for calculating the age (month) is: datedif(b2,c2,"ym")。

Please refer to it.

When you join A2, enter =DateDif(A2,Today(),) in B2"y")&"years"&datedif(a2,today(),"ym")&"month"&datedif(a2,today(),"md")&"day"

But I don't know what happened to my computer, and the age of the division appeared for 5 years, 5 months, and 132 days. Please help, thank you.

Assuming that the entry time is A2 and the company age (year) is B2, you can enter "=DateDif(text(mid(A2,7,6+2*(len(A37)=18))," in B2"#-00-00"),now(),"y")。I don't know if it's the one you need.

Tell me more about it? I don't understand what you mean!

The steps to solve the excel calculation based on the entry date division age formula calculation are as follows:

1.Open the required excel file; Insert a column in front of the record year as the record column for the current date, titled "Current Date", which is the date of the current day.

2.Write "=now()" in the ** of the current date without double quotation marks, and then press enter to automatically display the date of the day, and then copy it to the other ** below; Note: You don't need to write any arguments in the parentheses of this function, just leave it empty.

3.Write the formula shown in the figure in the column of the year column, where the time interval in parentheses is "current date" minus "entry date", and then divide this time interval by the number of days in a year 365 (the number of days per year can be filled in according to the actual number of years in the year) to get the number of years of employment.

4.Copy the above formula into the other ** of the column. This solves the problem of excel calculating the steps of the seniority formula based on the date of entry.

Division Age Formula: Suppose the date of entry into the company is in cell B1, enter C1.

datedif(b1,now(),y") to obtain the "year of age" calculated according to the "year old" method.

datedif(b1,now(),m"Obtain the "sleepy month age" calculated according to the "one year" method.

Suppose column A is the entry time, and column B is the age of the company.

B2 cell formula: month(now())month(a2) Note: The date of A2 must be in the default time format of excel, and the year, month and day are separated by , such as 15 11 21, if you use 20151121, it cannot be established.

First of all, excel provides a lot of date functions, but to use these date functions directly, you have to enter the date data according to the date format specified by excel, that is, the date data is a whole, instead of you divide the year, month and day into 3 independent data, such as July 1, 2015, directly enter in a cell: 2015 7 1, you can format the date data in the cell, and choose a date format that you like.

Secondly, by typing your data separately, it is obvious that your month and day data are not really "numbers", but "text" - there is a display mark on the left side of the cell.

Third, try not to merge cells in the worksheet, such as in your table, the year, month and day rows can be completely omitted, so that you can avoid merging cells. In particular, if you enter it in the way I said in the first article, it is more clear, and you should not write "year, month and day" on an extra line at all.

Fourth, I don't know if your ** really needs so many columns, if there are a lot of empty columns in the middle, then it's not necessary. That can cause some trouble for later data processing.

datedif(date(q4,r4,s4),today(),"y")

The premise is to convert the text month and day to text first, and if you don't convert first, the formula should be written as:

datedif(date(q4,--r4,--s4),today(),"y")

That is, first use two negative numbers to convert text numbers into real numbers.

However, if the date data is entered in the same way as described in Article 1, such as the entry time in Q4, the formula for the age of the company is much simpler:

datedif(q4,today(),"y")

If the age of the company is "Entry time" to the current number of years, then enter the following formula in the AS4 cell and then fill in the formula down.

if(q4="","",datedif(date(q4,r4,s4),today(),"y"))

See datedif (start date, end date,"m"）

Note, m is the month, if y, it is the year, if d, it is the number of days, according to your needs.

Who does [Si Ling] have a relationship with and what is the relationship?

1. To use the datedif function to calculate, the formula for the mu file is: "=datedif("entry time", "calculation node", "m")" where m means calculated by month, if the calculation node is today, you can use the today() function;

2. It is calculated from the time of entry, and if you leave the job during the period, you must recalculate;

3. If the entry time is February 15, 2007 and ends on December 31, 2007, then the age of the company is 10 months and 17 days.