How To Make Days Of The Week Or Letters Calculate

  • Thread starter Thread starter BENJAMINTHEBLUE
  • Start date Start date
B

BENJAMINTHEBLUE

Hi, I would really like some help with making days of the week and
letters calculate:
for example i have cycles of software such as

MONDAY A
TUESDAY A
WEDNESDAY A
THURSDAY A
FRIDAY A
SATURDAY A
SUNDAY A

THEN
MONDAY B
TUESDAYB
WEDNESDAYB ect......
Then it goes back to cycle A (not c)
I am looking for a way to automatically calculate the next cycle.
I have tried having 2 different cells and formatting the day with a "d"
then put cell number = a1-1 but it was a bit hopeful that would work.
If anyone could just point me in the right direction, bearing in mind
i am not allowed to use visual basic, I would be very grateful
thx Ben
 
You can enter the following formula in cell A2, and copy down as far as
required:

=TEXT(ROW(),"dddd")&IF(MOD(ROW()-2,14)<=6," A"," B")
 
Hi,

That seems to work great and will really help me in creating cycle
listings. I was having a bit of difficulty in getting it to work
on my current form, as the cells with "monday a" ect are on different
parts of the worsheet and must update backwards.
ie if cell a1 = monday a, then i have to get cell a 200 to show
sunday b and also automatically change if cell a1 is changed.
If you can help..GREAT! and if not you have pointed me in the right
direction.
Many Thanks Ben
 
Back
Top