1

I know very little about Google Sheets and all I want to do is create a cell that will display the beginning and end of the week, like this: 7/22-7/28.

I'd like to be able to drag this across multiple cells and have it be the next week's dates. Can anyone help with this?

2 Answers 2

3

A1:

=ARRAYFORMULA(JOIN("-",TEXT({"7/22","7/28"}+(COLUMN(A1)-1)*7,"M/DD")))

Drag to right.

  • Two dates are initialized and a column number*7 is added per each column.
  • TEXT to format dates " m/dd"
  • JOIN the 2 dates by -
0
1

with one more column:

  • cell A1: =TEXT(DATE(2018,7,15)+B1,"m/d")&"-"&TEXT(DATE(2018,7,21)+B1,"m/d")

  • cell B1: 7

  • cell B2: =B1+7

and then drag down A1 and B2

https://docs.google.com/spreadsheets/d/

Your Answer

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