Change cell in formula based on date
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.
|