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

Index match with multiple criteria(different than usual) 0
Index match with multiple criteria(different than usual) 3
Next weekday ... 3
Conditional Format with Name Range? 1
automatically populate cells 0
Microsoft 365 Home edition - one drive duplicates 0
SumIf with multiple Criteria 6
Reference to another worksheet cell in a sumproduct formula 1

Top