![]() ![]() ![]() ![]() Step 3: Again, use YEAR(A2) to extract the year from the date present under cell A2. Step 2: Now, use the subtract operator to subtract between two date years. It will extract the year from the date present under cell B2. Step 1: In cell D2, use the =YEAR(B2) formula. Since we need to determine the difference between the years of the Second Date and the First Date, we’ll use the YEAR() function in Excel to determine the difference in years. Now, we will be looking to figure out how to find a difference between two dates in a number of years. After selecting all the working cells, you can hit keyboard strokes Ctrl + D.Įxample #2 – Two Dates in Number of Years Step 3: Drag the formula until the last working row, and you can see the difference between all dates in a number of days, as shown below. You now can see the difference between the two dates as a number of days as shown below: Step 2: Select the entire column C and click on the Home tab under the Number group section select General or Number formatting through the dropdown list to convert it into numbers. Press the Enter key, and you’ll get the difference between the two dates as shown below: Step 1: In cell C2, use a usual subtraction method to subtract the First Date from the Second Date. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |