Conditional cell reference

  • Thread starter Thread starter guy
  • Start date Start date
G

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.
 
Hi
try something like
=IF(AND(TODAY()>=DATE(2004,1,1),TODAY<=DATE(2004,1,31)),A1,A2)

--
Regards
Frank Kabel
Frankfurt, Germany

guy said:
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
Click to expand...
will be =A2.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to reference two cells to construct formula 1
Enter data in cell referenced in a cell 4
How do I reference cells in CF formula within loop 2
setting one worksheet cell range reference to another worksheet 1
Copy Conditional Formatting 6
Problem with a loop and column references 27
VBA set thick borders around non empty cells in range 0
Cell Count Between Value 13

Back
Top