Formula Required

[rpriestley]

I have type the day Monaday in cell A1. What formula could I use that would automatically increased the day by 1 in cell B1, C1, D1 etc.
So for example if I typed Wednesday in A1, B1 would automatically display Thursday.

Thanks Robin

 

[Domenic]

Try...

B1, copied down:

=CHOOSE(INDEX({2,3,4,5,6,7,1},MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")

However, you could simply place the cursor over the lower right corner of A1 until the cursor changes, and then click and drag across.

Hope this helps!