Conditional cell reference
 

It is simple enough to have a cell reference another cell with a formula like so =A1

What if a cell reference is dependent on a date? For example, during the first 30 days in 2004, the
cell reference is =A1 and the next x number of days the reference will be =A2.

Conditional cell reference
 

Hi
try something like
=IF(AND(TODAY()=DATE(2004,1,1),TODAY<=DATE(2004,1 ,31)),A1,A2)

--
Regards
Frank Kabel
Frankfurt, Germany

"guy" schrieb im Newsbeitrag
...
It is simple enough to have a cell reference another cell with a
formula like so =A1

What if a cell reference is dependent on a date? For example, during
the first 30 days in 2004, the
cell reference is =A1 and the next x number of days the reference
will be =A2.