Fill series - odd days/months

[FloydPalmer]

Hi,

I'm following Microsoft Virtual Academy's Excel tutorial and I've come across different ways to use the fill series and I wanted to ask how you can do a fill series if you wanted to do odd days/months (so Monday, Wednesday, Friday or months Apr, June, Sept).

After writing April, June and using the arrow to drag down (the tutorial suggested Excel would pick it up automatically) it gives the multiple options but I'm still unable to get the odd months I need.

I've tried going into Fill > Series > Date > Month > Step Value (2) but no joy.

Can anyone break it down so I can do this?

Thanks

 

[oldbrewer]

months Apr, June, Sept).

are the next months Nov Jan Apr ?

 

[Scott Huish]

This formula copied down will repeat the days of the week starting with Monday:
=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")

This formula copied down will repeat those months:
=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")

Excel 2010
	A	B
1	Mon	Apr
2	Wed	Jun
3	Fri	Sept
4	Mon	Apr
5	Wed	Jun
6	Fri	Sept
7	Mon	Apr
8	Wed	Jun
9	Fri	Sept
10	Mon	Apr
Sheet1

Cell Formulas
Range	Formula
A1	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A2	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A3	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A4	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A5	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A6	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A7	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A8	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A9	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
A10	=TEXT((MOD(ROW()-1,3)+1)*2,"ddd")
B1	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B2	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B3	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B4	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B5	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B6	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B7	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B8	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B9	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")
B10	=CHOOSE(MOD(ROW()-1,3)+1,"Apr","Jun","Sept")

 

[Dave Patton]

Excel 2010
	A	B	C
1	Months	Months	Days
2	April	Apr	Mon Oct 01 2018
3	June	Jun	Wed Oct 03 2018
4	August	Aug	Fri Oct 05 2018
5	October	Oct	Mon Oct 08 2018
6	December	Dec	Wed Oct 10 2018
7	February	Feb	Fri Oct 12 2018
8	April	Apr	Mon Oct 15 2018
9
Month series

Cell Formulas
Range	Formula
C3	=IF(WEEKDAY(C2,1)<6,C2+2,C2+3)

Fill down seems to work OK with Months see Columns A or B
Try the formula for Mon Wed and Fri

Hopefully this helps.
Please provide more information on what you require.

N.B. Format column C to show just Mon etc if that is what you require.

 

[FloydPalmer]

Excel 2010

	A	B	C
Months	Months	Days
April	Apr
June	Jun
August	Aug
October	Oct
December	Dec
February	Feb
April	Apr

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]Mon Oct 01 2018[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]Wed Oct 03 2018[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]Fri Oct 05 2018[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]Mon Oct 08 2018[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]Wed Oct 10 2018[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]Fri Oct 12 2018[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]Mon Oct 15 2018[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Month series​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]C3[/TH]
[TD="align: left"]=IF(WEEKDAY(C2,1)<6,C2+2,C2+3)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Fill down seems to work OK with Months see Columns A or B
Try the formula for Mon Wed and Fri

Hopefully this helps.
Please provide more information on what you require.

N.B. Format column C to show just Mon etc if that is what you require.

Thank you - most informative. However, and sorry I didn't make it clear, is that rather than repeat the days and months I'd want to keep the formula going so the days/months continue in that format?

Incidentally, our quarters would normally go as April, June, Sept, Dec, March

 

[Scott Huish]

How do you want the days of the week to go since there are only 7 days in a week.
Mon Wed Fri Sun Mon or do those days actually repeat Mon Wed Fri Wed

Why don't your quarters always repeat starting at the same Month? It seems like they should go March, June, Sept, Dec, Mar