I would like to have a formula that draws from different cells depending on
the current date. For instance, on the first of the month, it will draw from
A1, and on the second it will draw from A2, etc.

I just experimented with this and it worked (note: I used column b instead of
a)
=INDIRECT("b"&DAY(NOW()))

"Skillet" wrote:

I would like to have a formula that draws from different cells depending on
the current date. For instance, on the first of the month, it will draw from
A1, and on the second it will draw from A2, etc.

One way:

=INDEX(A:A,DAY(TODAY()))

In article ,
"Skillet" wrote:

I would like to have a formula that draws from different cells depending on
the current date. For instance, on the first of the month, it will draw from
A1, and on the second it will draw from A2, etc.

This is exactly what I was looking for, thanks guys!


"Skillet" wrote:

I would like to have a formula that draws from different cells depending on
the current date. For instance, on the first of the month, it will draw from
A1, and on the second it will draw from A2, etc.