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

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


--
Regards!
Stefi



€žbcags7€� ezt Ã*rta:

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

Try this

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

HTH

Bob

"bcags7" wrote in message
...
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

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?

"Stefi" wrote:

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


--
Regards!
Stefi



€žbcags7€� ezt Ã*rta:

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

See my earlier response, that will work.

HTH

Bob

"bcags7" wrote in message
...
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?

"Stefi" wrote:

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


--
Regards!
Stefi



"bcags7" ezt írta:

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

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:

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?

"Stefi" wrote:

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


--
Regards!
Stefi



€žbcags7€� ezt Ã*rta:

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