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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.