How to 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:

Google sheets calculate future date by adding days

Column B displays the date that is 50 days after the corresponding date in column A.

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:

Google sheets calculate future date by adding business days

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 here.

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:

Google Sheets calculate future date by adding months

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 here.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Extract Date from Text String
Google Sheets: How to Find Most Recent Date
Google Sheets: How to Filter Dates by Month

Leave a Reply

Your email address will not be published. Required fields are marked *