Google-sheets – How to enter a date in a cell and have the date for one week later automatically fill another cell

dategoogle sheets

I want to be able to type in a date in one cell, and then automatically have the date that is seven days from the date I typed appear in another cell in that same row under a different column. How do I do this?

Best Answer

You can use this formula.

Formula

=ARRAYFORMULA(IF(ISBLANK(A2:A),"",A2:A + 7))

Screenshot

enter image description here

Example

I've created an example file for you: new date from entered date

Related Solutions

Google-sheets – How to apply formatting to another cell based on whether another cell’s date has passed or not

This is similar to Conditional formatting based on comparison with today's date and also with a future date except you want to format another cell, not the one with the date.

Select the range of names (for example, A2:A10)
Apply conditional formatting with Custom formula... =B2<TODAY(). Here B2 appears because it is the correct cell to look at when formatting A2, the top of the range. For the cells A3, A4, ... the formula will automatically be interpreted correctly.

Google Sheets – Add Cell Contents to Another Cell and Delete Original

This requires a script, for example:

function onEdit(e) {
  if (e.range.rowStart == 2) {
    var below = e.range.offset(1, 0);
    below.setValue(Number(e.value) + Number(below.getValue()));
    e.range.clear();
  }
}

Here the watched range is the 2nd row (the condition e.range.rowStart == 2). If a number is entered there, then it's added to the content of the cell below, and the cell itself is cleared.

Using Number to avoid string concatenation 2 + 2 = 22 instead of addition.

Same for rows 2 and 6: the notation || means OR:

function onEdit(e) {
  if (e.range.rowStart == 2 || e.range.rowStart == 6) {
    var below = e.range.offset(1, 0);
    below.setValue(Number(e.value) + Number(below.getValue()));
    e.range.clear();
  }
}