SOLVED

Weekly intervals within single cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-1433318%22%20slang%3D%22en-US%22%3EWeekly%20intervals%20within%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433318%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20to%20set%20up%20a%20list%20with%20automated%20weekly%20intervalls%20within%20a%20single%20cell%3F%20I%20want%20it%20to%20read%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECell%201%3A%2001.06.2020-07.06.2020%3CBR%20%2F%3ECell%202%3A%2008.06.2020-14.06.2020%3CBR%20%2F%3EEtc%2015.06.2020-21.06.2020%3CBR%20%2F%3E22.06.2020-28.06.2020%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EEtc.%20Is%20there%20a%20formula%20I%20can%20use%3F%26nbsp%3B%3C%2FP%3E%3CP%3EGratefull%20for%20all%20tips.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%26nbsp%3B%3C%2FP%3E%3CP%3EM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433360%22%20slang%3D%22en-US%22%3ERe%3A%20Weekly%20intervals%20within%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433360%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686578%22%20target%3D%22_blank%22%3E%40mhar985%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20weeknum%20which%20returns%20the%20week%20number%20for%20the%20subsequent%20date.%20You%20can%20use%20the%20week%20number%20for%20your%20list.%20Refer%20to%20below%20image%2C%20hope%20this%20helps%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22saybhatt_0-1591105408093.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195903i801221A001C4793E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22saybhatt_0-1591105408093.png%22%20alt%3D%22saybhatt_0-1591105408093.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433869%22%20slang%3D%22en-US%22%3ERe%3A%20Weekly%20intervals%20within%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686578%22%20target%3D%22_blank%22%3E%40mhar985%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20file%2C%20using%20the%20following%20formula%20with%20the%20starting%20date%20in%20A1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXT(%24A%241%2B(ROW()-1)*7%2C%22dd.mm.yyyy%22)%26amp%3B%22-%22%26amp%3B(TEXT(%24A%241%2B(ROW()-1)*7%2B6%2C%22dd.mm.yyyy%22))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435289%22%20slang%3D%22en-US%22%3ERe%3A%20Weekly%20intervals%20within%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435289%22%20slang%3D%22en-US%22%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%2C%20this%20was%20magic.%20Dont%20know%20what%20it%20jumped%20two%20weeks%20from%20A1%2C%20but%20fixed%20it%20by%20setting%20the%20start%20date%20earlier.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435290%22%20slang%3D%22en-US%22%3ERe%3A%20Weekly%20intervals%20within%20single%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted
Best Response confirmed by mhar985 (Occasional 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"))

 

 

Highlighted
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.
Highlighted