Table of Contents
Calculating a future date in Google Sheets can be done easily by using the built-in functions and formulas available. To do this, you will need to use the DATE function which takes in three arguments: year, month, and day. Simply input the desired future date in the appropriate cells and use the DATE function to add or subtract the number of days, months, or years to get the future date. You can also use the TODAY function to automatically calculate the current date and add or subtract from it to get the future date. This feature is particularly useful for planning and scheduling tasks or events. With the help of Google Sheets, you can easily and accurately calculate future dates without any hassle.
Calculate a Future Date in Google Sheets
You can use the following formulas to calculate a future date in Google Sheets:
Method 1: Calculate Future Date by Adding Days
=A2+50
This particular example will return the date that is 50 days after the date in cell A2.
Method 2: Calculate Future Date by Adding Business Days
=WORKDAY(A2, 50)
This particular example will return the date that is 50 business days after the date in cell A2.
Method 3: Calculate Future Date by Adding Months
=EDATE(A2, 3)
This particular example will return the date that is 3 months after the date in cell A2.
The following examples show how to use each method in practice with the following list of dates in Google Sheets:
Example 1: Calculate Future Date by Adding Days
We can type the following formula into cell B2 to return the date that is 50 days after the date in cell A2:
=A2+50
We can then click and drag this formula down to each remaining cell in column B:
Example 2: Calculate Future Date by Adding Business Days
We can type the following formula into cell B2 to return the date that is 50 business days after the date in cell A2:
=WORKDAY(A2, 50)
We can then click and drag this formula down to each remaining cell in column B:
Column B displays the date that is 50 business days after the corresponding date in column A.
Note: You can find the complete documentation for the WORKDAY function in Google Sheets .
Example 3: Calculate Future Date by Adding Months
We can type the following formula into cell B2 to return the date that is 3 months after the date in cell A2:
=EDATE(A2, 3)
We can then click and drag this formula down to each remaining cell in column B:
Column B displays the date that is 3 months after the corresponding date in column A.
Note: You can find the complete documentation for the EDATE function in Google Sheets .
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets: