Add Days to a Date (1 Day, 7 Days, & 30 Days) in Google Sheets

In Google Sheets, you can use the sum formula with the addition operator if you want to add a day or multiple days to a date.

Adding a Day or Two to a Date

1. Refer to the cell with the date.
2. Enter the sum operator.
3. Enter the number of days to add.
4. Hit enter to the new date.

In the above example, you have a date in cell A1 (01-Jan-2023), and by adding one to cell B1, you have the new date (02-Jan-2023).

Add 7 Days to Today’s Date

Let’s say you want to add 7days to today’s date.

1. Enter “=TODAY()” in a cell.
2. Type the sum operator (+).
3. Now enter the days which you want to add (7).
4. In the end, hit enter to get the seven days ahead from today’s date.

=TODAY()+7

Today is a 26-April-2023; I’m writing this, and adding 7 days to it gives me 03 May 2023, which is 7 days ahead of today’s date.

=TODAY()+7

When you use the function TODAY, which is a volatile function, it changes its value when you update any value in the worksheet. You can change these settings from File > Settings > Calculation.

Subtract Days from a Date

In the same way, you can subtract days from the date. In this case, you can use the subtract operator (minus sign) instead of the addition.

Let’s say you want to subtract 7 days from a date you have in cell A1; refer to cell A1, enter the minus sign and days you want to subtract.

⮞ Get the Sample Sheet