Day finder

[esamuel]

Hi there.

Is there a way so if I put 'Mon' in one cell the next 6 cells across automatically enter Tue, Wed, etc? So if I start with 'Fri' the next cell till start at Sat and so fourth.

Cheers, E

 

[FormR]

Hi, here is one option, the formula in B1 is copied across.

Excel 2013/2016
	A	B	C	D	E	F	G
1	Sun	Mon	Tue	Wed	Thu	Fri	Sat
Sheet1

Cell Formulas
Range	Formula
B1	=TEXT(DATE(0,1,MATCH(A1,{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"},0)+1),"ddd")

 

[MickG]

Maybe !!
[TABLE="width: 48"]
<colgroup><col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]http://www.excel-easy.com/examples/custom-lists.html[/TD]
[/TR]
</tbody>[/TABLE]

 

[esamuel]

Cheers FormR that worked perfectly!

 

[Peter_SSs]

.. yet another option

Book1
	A	B	C	D	E	F	G
1	Sun	Mon	Tue	Wed	Thu	Fri	Sat
Days

Cell Formulas
Range	Formula
B1	=MID("MonTueWedThuFriSatSun",FIND(A1,"SunMonTueWedThuFriSat"),3)