View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default subtract one weekday

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