How to return the next day of the week, by referencing a Text day of the week?

[Mark McInerney]

Hi,

I have a cell A1 where I type in the day of the week e.g. "Monday", and I want the cells to the right, B1 to populate with the next day e.g. "Tuesday".

Thanks in Advance for any help - Mark.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Here are a couple of options, depending on your version information.

22 08 25.xlsm
	A	B	C
1	Monday	Tuesday	Tuesday
Days

Cell Formulas
Range	Formula
B1	B1	=LET(days,TEXT(SEQUENCE(8),"dddd"),INDEX(days,MATCH(A1,days,0)+1))
C1	C1	=INDEX({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday"}, MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday"},0)+1)

You can also do it pretty quickly manually by dragging the Fill Handle to the right.

 

[Mark McInerney]

Thank you - works a treat.

 

[Peter_SSs]

You're welcome.

.. but please still update your version information as requested.

 

[FormR]

Hi, just another option..

Book1
	A	B
1	Monday	Tuesday
2	Tuesday	Wednesday
3	Wednesday	Thursday
4	Thursday	Friday
5	Friday	Saturday
6	Saturday	Sunday
7	Sunday	Monday
Sheet1

Cell Formulas
Range	Formula
B1:B7	B1	=TEXT((FIND(LEFT(A1,2),"SaSuMoTuWeThFr")+1)/2,"dddd")