embedding NOW function in OFFSET

[tjb]

trying to get the NOW function to work as suggested but
having difficulties.

------------------------------------------------------

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

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag

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.

..

 

[Domenic]

trying to get the NOW function to work as suggested but
having difficulties.

=OFFSET($A$1,,WEEKDAY(NOW(),2))

Hope this helps!