Day Formula

[rpriestley]

I have the Day Monday in cell A1. What formula could I use to to increase the day by 1 for b1,c1,d1,e1 ETC. So for example if I typed tuesday in A1 automatically Wednesday would appear in B1

 

[GlennUK]

Do you really want this via formula? If you drag the fill handle to fill in the required cells they will fill in with the required days.

 

[Peter_SSs]

I would go with dragging the Fill Handle too.

However, if a formula is a must, you could try this one in B1 and copy across as far as you like.

Excel Workbook
	A	B	C	D	E	F
1	Monday	Tuesday	Wednesday	Thursday	Friday
2
Next Day