Subtract Dates With the YEAR Function
Subtracting dates with the YEAR function may be helpful if you want to adjust a project’s scheduled date or experiment with how long a single activity would take. In this example, we want to find out the number of years between two dates. Our final formula will look like this: = YEAR ( D1 ) - YEAR ( D2 ) To enter the formula into Excel we can either type it into cell E1 with the two dates to be subtracted in cells D1 and D2, or use the YEAR function dialog box to enter the formula into cell E1. In this example, we’ll use the dialog box method to enter the formula. Since the formula involves subtracting two dates, we’ll enter the YEAR function twice using the dialog box.
Enter the Date in Initially
These are the steps to enter in the date the first of two times.
Enter the Date in a Second Time
Now we’ll enter the date a second time to complete the process. D1: 7/25/2009 D2: 5/16/1962
