T
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
..
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.
..