SOLVED

Weekly intervals within single cell?

Copper Contributor

Hi, 

 

Can anyone help me to set up a list with automated weekly intervalls within a single cell? I want it to read: 

 

Cell 1: 01.06.2020-07.06.2020
Cell 2: 08.06.2020-14.06.2020
Etc 15.06.2020-21.06.2020
22.06.2020-28.06.2020


Etc. Is there a formula I can use? 

Gratefull for all tips. 

 

Best, 

M

3 Replies
best response confirmed by mhar985 (Copper Contributor)
Solution

@mhar985 Perhaps like in the attached file, using the following formula with the starting date in A1

 

=TEXT($A$1+(ROW()-1)*7,"dd.mm.yyyy")&"-"&(TEXT($A$1+(ROW()-1)*7+6,"dd.mm.yyyy"))

 

 

Thank you @Riny_van_Eekelen, this was magic. Dont know what it jumped two weeks from A1, but fixed it by setting the start date earlier.
1 best response

Accepted Solutions
best response confirmed by mhar985 (Copper Contributor)
Solution

@mhar985 Perhaps like in the attached file, using the following formula with the starting date in A1

 

=TEXT($A$1+(ROW()-1)*7,"dd.mm.yyyy")&"-"&(TEXT($A$1+(ROW()-1)*7+6,"dd.mm.yyyy"))

 

 

View solution in original post