Google-sheets – How to add dates for the beginning and end of the week in one cell

formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-cell-formatgoogle-sheets-dates

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?

Best Answer

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 -
Related Topic