How to Add the Number of Years Months and Days to a Date in Google Sheets?

Manually adding days or months to a given date can be a messy and time-consuming process. We can solve this problem easily by using formulas. This article will help you understand how we can add the number of years, months, and days to a date in Google Sheets. In this tutorial, we will see about adding days, months, and years to a given date.

Adding Number of Years Months and Days to a Date

Here we will get any one of the results using the DATE formula, then use the auto-fill handle to get all the results. Let's look at a simple procedure for adding the number of years to a date in a Google Sheet.

Step 1

Let us consider a Google Sheet where the data in the sheet is similar to the data shown in the below image.

Now, in our case, click on the empty cell C2 and enter the formula −

=DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2)) and press Enter to get the first result. In the formula, A2 is the date's address, and B2 is the number of years to be added.

Step 2

Now drag from the first result using the autofill handle, and our final result will be similar to the below image.

Adding Number of Months to a Date

To complete our task, we will first obtain a value using the EDATE formula, then convert it to date. Let's look at a simple procedure for adding the number of months to a date in a Google Sheet.

Step 1

Consider the same data as in the previous example and click on the empty cell, enter the formula =EDATE(A2,B2), and press enter to get the first result.

Step 2

Then, from the first result, drag to get all the others. By selecting the values, clicking on the number, and then selecting a short date, we can convert them to dates.

Drag down > Select values > Number > Short date

Adding Number of Days to a Date

Here we will directly add number of days to a date. Let us see a simple process to know how we can add number of days to date in google sheets.

Step 1

Let us consider the same data that we used in the examples above and click on an empty cell, enter the formula =A2+B2, and click enter to get our first result.

Step 2

Now drag down from the first result to fill all the results, and our final output will be similar to the below image.

Conclusion

In this tutorial, we used a simple example to demonstrate how you can use the number of months to date in Excel to highlight a particular set of data.