In this tutorial, you will learn how to add months to date in Google Sheets.
How to Add Months to Date in Google Sheets
Google Sheets comes with various built-in functions to make it easy to work with dates. One common task you might have to do is adding an arbitrary number of months to a date.
For example, you may have a date and you need to find the date that is exactly six months from the original date. In Google Sheets, we can perform this calculation easily with the EDATE function.
This guide will show you how to add months to a date in Google Sheets using the EDATE function.
How to Add Months to a Given Date in Google Sheets
Here’s our step-by-step guide on how to add months to a given date in Google Sheets.
Step 1
First, select an empty cell to place our new date.
In this example, we have a column with initial dates and another column that indicates how many months to add to the date. We want to return this new date in column C.
Step 2
Type the EDATE function into the empty cell.
Step 3
The EDATE function accepts two parameters. The first parameter refers to the initial date. The second parameter indicates how many months to add to the provided date. The function should return a new date value that is x months after the initial date.
Step 4
Hit the Enter key to evaluate the EDATE function.
In our example above, we find out that the date six months after January 25, 2023 is July 25th.
Step 5
We can use the AutoFill feature to find the remaining dates.
Step 6
We can also subtract months using EDATE. The second argument must be written as a negative number.
Summary
This guide should be everything you need to learn to start adding months to a date in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.