Day + 1 Day in Text ???

Microsoft Microsoft excel 2007 full vers...
November 4, 2011 at 05:03:18
Specs: Windows XP
Help.

If Cell A1 is 'Monday' how can I make cell B5 "Tuesday"

Thank you


See More: Day + 1 Day in Text ???

Report •


#1
November 4, 2011 at 08:26:07
How did Monday get into A1?

Was it entered as text or as the result of formula?

In any case, this might work...

=CHOOSE(MATCH(A1,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0),
"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 7, 2011 at 02:45:58
MONDAY is Text.

thank you for your response.. unfortunatly I couldnt get it to work.


Report •

#3
November 7, 2011 at 09:59:10
Don't know why...it works fine for me, returning the next day's name based on the day name in A1.

What does "couldn't get it to work" mean?

Since I can't see your spreadsheet from where I'm sitting, it's a bit difficult for me to diagnose "couldn't get it to work".

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question