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
What type of data are SUN-SAT? Are they real Excel dates custom formatted like "ddd" or strings (texts)? -- Regards! Stefi ???bcags7??? ezt ??rta:
Try this =LOOKUP(Sheet3!A2,{"FRI","MON","SAT","SUN","THU","TUE","WED"},{"THU","SUN","FRI","SAT","WED","MON","TUE"}) HTH Bob
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?
See my earlier response, that will work. HTH Bob
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: