auto cell update

[tjb]

I need to be able to have a cell change dynamically every
day, is there a way to automate that process?

For instance, I want cell A1 to say what is in cell B1 on
Mondays, cell C1 on Tuesdays, cell D1 on Wednesdays and
so on. Is there a way to automate this without even
having the workbook opened?

I'm linking to this cell from another workbook which is
why I want it automated.

 

[Frank Kabel]

Hi
use the NOW function. e.g. try in A1:
=OFFSET($A$1,WEEKDAY(NOW(),2),0)

 

[Guest]

trying to get this to work but not following it, can you
clarify this for me?

 

[Frank Kabel]

Hi
just enter this formula in cell A1. The WEEKDAY function will return
the weekday number (1=Monday, 7=Sunday) for the current date
(identified with the function NOW)