subtract one weekday

B

bcags7

In one worksheet I've 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
 
S

Stefi

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


--
Regards!
Stefi



„bcags7†ezt írta:
 
B

Bob Phillips

Try this

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

HTH

Bob
 
B

bcags7

I'm 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?
 
S

Stefi

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


--
Regards!
Stefi



„bcags7†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIf with multiple Criteria 6
Conditional Format with Name Range? 1
Populate cells automatically 1
Reference to another worksheet cell in a sumproduct formula 1
Worksheet Links 1
Next weekday ... 3
got to cell on seperate worksheet 2
WEEKDAY question on year 2

Top