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 !!

http://www.excel-easy.com/examples/custom-lists.html

<colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[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)