Jun 02 2020 06:20 AM
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
Jun 02 2020 09:36 AM - edited Jun 02 2020 09:39 AM
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"))
Jun 02 2020 11:40 PM
Jun 02 2020 09:36 AM - edited Jun 02 2020 09:39 AM
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"))