Conditional cell reference

[guy]

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.

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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.