autocompletion

[msword]

Is it possible to autofill cells with dates 2 times/week for 3 month e.g. Wednesdays and Sundays from January 29 to April 29:
Jan 29 2022, Feb 02 2022, Feb 05 2022, Feb 09 2022, Feb 12 2022 etc.
I tried to write down first 5 dates manually and extend them with mouse but Excel didn't get that and instead started a loop from the 1st date (Jan 29 2022) instead of Feb 16 2022.
Is there a way to extend dates automatically? Otherwise it's a hell job to do it manually.

 

[mikerickson]

Jan 29, 2022 is neither a Sunday nor a Wednesday.

You could put
1/30/2022 in A1
2/2/2022 in A2
and =A1+7 in A3 and drag the formula down.

 

[msword]

Jan 29, 2022 is neither a Sunday nor a Wednesday.

Of course I meant Saturday, not Sunday, but original post is not editable anymore.

You could put
1/30/2022 in A1
2/2/2022 in A2
and =A1+7 in A3 and drag the formula down.

In that case, after extension I get: Feb 6, Feb 10 and Feb 13 instead of the dates I need: Feb 9, Feb 12 and Feb 16.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	29/01/2022	02/02/2022	05/02/2022	09/02/2022	12/02/2022	16/02/2022	19/02/2022	23/02/2022	26/02/2022	02/03/2022	05/03/2022
Lists

Cell Formulas
Range	Formula
B1:K1	B1	=WORKDAY.INTL(A1,1,"1101101")

 

[mikerickson]

Of course I meant Saturday, not Sunday, but original post is not editable anymore.

In that case, after extension I get: Feb 6, Feb 10 and Feb 13 instead of the dates I need: Feb 9, Feb 12 and Feb 16.

When I tested, I got the dates Feb 6, Feb 9, Feb 13. Not Feb 10,
Are you sure that 2/2/22 was what was entered in A2? and that the dragging down put =A2+7 in cell A4?


If you want a different day of the week, have you tried to change the start dates to suit your taste?

 

[msword]

@mikerickson Thanks, but still it's not the dates what i need (Feb 9, Feb 12 and Feb 16). The first date is Jan 29 2022.
@Fluff Thanks for that elegant solution it works like a charm!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[msword]

Is it possible to do the same but for occurrences once per 2 weeks e.g. 2022 Jan 1, 2022 Jan 15, 2022 Jan 29, 2022 Feb 12 etc. ?

 

[Fluff]

You can use

=WORKDAY.INTL(A1,2,"1111101")

 

[msword]

@Fluff This is amazing! I love this forum!