3

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?

2

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

  • 1
    I like your answer, but isn't the OP just talking about "one cell", so the range/ARRAYFORMULA would seem to be unnecessary? – MrWhite Feb 7 '15 at 1:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.