We can use EDATE() for years by multiplying the given number of years by 12 and using the resulting number of months as the second argument in the EDATE(). Let us see the steps with an example. Assume we have to initiate a contract on 1-10-2022. And we have different contract terms in years, as depicted in the below image. Suppose we have to calculate the contract termination dates based on the contract initiation dates and contract terms in the target cell range C2:C6. Then here is how we can apply the EDATE() to the target cells to get the required date values. • Step 1: Select the target cell C2, enter the following EDATE(), and press Enter. =EDATE(A2,12*B2) • Step 2: Drag the fill handle downwards to copy the formulas in cell range C3:C6. Let us consider the target cell C6 formula to understand how the EDATE() has worked for years. The start_date argument is a date value of 1-10-2022. While the unit of the contract term values is years, the second argument in the EDATE() is months. So, we can convert the contract term years into months to provide it as the second argument to the function. Since a year has 12 months, we multiply the given number of years, 12, by 12 months. The EDATE() then adds 144 months (12*12) to the given start_date to return the contract termination date as 1-10-2034, a date 12 years from 1-10-2022.