Use the year function to calculate the age difference for two dates in Excel2013

Every two dates will have a time difference, in the Excel2013, there are functions that can calculate this margin, today we will learn to calculate the two-year difference in the number of functions.

Specific procedures

To open a worksheet with Excel2013, we now need to find the difference in the number of years between column B and column A in C column, select C2 cell, and enter the function "=year (B2)-year (A2)".

When we press the ENTER key, the C2 cell will show the difference in the number of years between the B2 and the A2 cell, we put the mouse in the lower right of the C2 cell, press the mouse when the cursor becomes a cross, and drag to the C4 cell.

When we release the mouse, we see the effect that column C automatically fills the formula, and the C3 and C4 cells also calculate the number of years between the two dates in the row.

Conclusion: After the above experiment, we know that the year function only extracts the value of the beginning of the date, which is not related to the following month.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join