How to Add Weeks to Date in Google Sheets

To add weeks to a date in Google Sheets, you can use the EDATE function, which allows you to add a specified number of months to a given date. Since a week has approximately 4.3 weeks, you can convert weeks to months and then use the EDATE function. Alternatively, you can use the simpler method of adding the number of days directly to the date using simple addition.

Here's how you can do it:

Using EDATE function

1. Open your Google Sheets document.
2. Click on a cell where you want the result to be displayed.
3. Type the following formula, replacing A1 with the cell containing the start date and B1 with the cell containing the number of weeks you want to add:

=EDATE(A1, B1*7/30.44)

4. Press Enter, and the new date will be displayed in the selected cell.

Using simple addition

1. Open your Google Sheets document.
2. Click on a cell where you want the result to be displayed.
3. Type the following formula, replacing A1 with the cell containing the start date and B1 with the cell containing the number of weeks you want to add:

=A1 + (B1 * 7)

4. Press Enter, and the new date will be displayed in the selected cell.

Example

Date:       10/15/2021
Weeks:      4

Using the EDATE function:

=EDATE(A1, B1*7/30.44) - This will return "11/12/2021".

Using simple addition:

=A1 + (B1 * 7) - This will return "11/12/2021".