Rotating 5 day display

[Newbienew]

Hello All,

I am looking for a formula that will display the 5-day work week in 5 cells but rotate the day that has past back to the end. So if today is Monday, the first cell would display it as Monday; when it because Tuesday, then everything would just shift, and not Tuesday would be in the first cell, and Monday would be in the last.

M

T

W

TH

F

I am also only looking to only display these characters. Is this at all possible

 

[Phuoc]

Like this?

Book1
	B	C	D	E	F
1	M	T	W	TH	F
Sheet1

Cell Formulas
Range	Formula
B1:F1	B1	=CHOOSE(WEEKDAY(WORKDAY(TODAY()-1,COLUMNS($B$1:B1)),2),"M"," T"," W"," TH"," F")

 

[Peter_SSs]

.. or this?

23 07 30.xlsm
	H	I	J	K	L
1	Monday	Tuesday	Wednesday	Thursday	Friday
Rotate Days

Cell Formulas
Range	Formula
H1:L1	H1	=TEXT(WORKDAY.INTL(TODAY()-1,COLUMNS($H:H)),"dddd")

 

[Tetra201]

See if these steps work for you:
1) Copy the following formula and place it in a cell of your choice (say, cell B2);

=CHOOSE(WEEKDAY(WORKDAY(TODAY()-1,{1,2,3,4,5}),2),"M","T","W","TH","F")

2) Starting from that cell, select four more cells to the right (i.e., range B2:F2);
3) Press the F2 key (you should see the cursor blinking at the end of the formula);
4) Press and hold the Ctrl and Shift keys, then press Enter (you should see the five selected cells populated).

 

[Newbienew]

Thank you all, I will reply back on Tuesday

 

[Newbienew]

They all worked out great. Thank you all very very much

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.