Auto fill

%3CLINGO-SUB%20id%3D%22lingo-sub-2074826%22%20slang%3D%22en-US%22%3EAuto%20fill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074826%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20i%20autofill%20date%20cells%20for%20weekly%20dates%2C%20ie%26nbsp%3B%3C%2FP%3E%3CP%3EBegin%20date%3C%2FP%3E%3CTABLE%20width%3D%22188%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2294%22%3E1%2F24%2F2021%3C%2FTD%3E%3CTD%20width%3D%2294%22%3E1%2F30%2F2021%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F31%2F2021%3C%2FTD%3E%3CTD%3E2%2F6%2F2021%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2074826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2075702%22%20slang%3D%22de-DE%22%3ESubject%3A%20Auto%20fill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2075702%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F934853%22%20target%3D%22_blank%22%3E%40pjstar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3D%20Date-WEEKDAY%20(date%2C%202)%20%2B1%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3D%20Date-WEEKDAY%20(date%2C%202)%20%2B7%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EGreeting%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20have%20to%20be%20careful%20with%20the%20calendar%20week%20function.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20could%20be%20that%20the%20calculation%20is%20based%20on%20the%20American%20standard%20that%20deviates%20from%20the%20European%20standard.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Add%20a%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project%2C%20for%20better%20understanding.%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do i autofill date cells for weekly dates, ie 

Begin date

1/24/20211/30/2021
1/31/20212/6/2021
3 Replies

@pjstar 

 

= Date-WEEKDAY (date, 2) +1

= Date-WEEKDAY (date, 2) +7

Greeting,

You have to be careful with the calendar week function.

It could be that the calculation is based on the American standard that deviates from the European standard.

 

* Add a MS Excel file (without sensitive data) to your project, for better understanding. Knowing the Excel version and operating system would also be an advantage.

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)

Hi @pjstar 

It seems you have a pattern here, 

it starts with Sun and end with Sat, and the next row start with the next Sun and ends on Sat

Just select the four cells and drag the courser down and it will auto fill them.

Please find the excel workbook attached

 

 

* If my post helped you, please click on like.

 

@pjstar 

One more variant

image.png

Enter in B2 first date, in another cells formulas as on the right and drag B3:C3 down till end of the dates range.

If you are on Excel with dynamic arrays you may use formula

=IF({1,0},SEQUENCE(52,1,DATE(2021,1,24),7),SEQUENCE(52,1,DATE(2021,1,24)+6,7))

and apply date format to the result

image.png