Excel - subtract one weekday

Asked By bcags7

03-Feb-10 03:01 AM

In one worksheet I have got weekdays (SUN-SAT). What I would like to do is link
those cells to another worksheet in the same workbook, but have them be minus
one day. For example: worksheet1 would have WED, but the linked cell in
worksheet2 would be TUE. Is there any way to do this?

Thanks in advance

03-Feb-10 03:32 AM

What type of data are SUN-SAT? Are they real Excel dates custom formatted
like "ddd" or strings (texts)?


--
Regards!
Stefi



???bcags7??? ezt ??rta:

03-Feb-10 04:02 AM

Try this

=LOOKUP(Sheet3!A2,{"FRI","MON","SAT","SUN","THU","TUE","WED"},{"THU","SUN","FRI","SAT","WED","MON","TUE"})

HTH

Bob

10-Feb-10 01:36 AM

I am not sure what data type they would be.  In the first cell I entered one
day (Mon) and auto-filled the rest of the row for a full month.  Would this
be a string?

10-Feb-10 05:32 AM

See my earlier response, that will work.

HTH

Bob

11-Feb-10 03:39 AM

Yes, they are strings, I'd have thought it, because real custom formatted
Excel dates are not fully in capitals (SUN-SAT) but Sun-Sat.


--
Regards!
Stefi



???bcags7??? ezt ??rta: