Cell Value and Dates

[ultracyclist]

I have a list of dates in column A using the format m/d/yy. For each of these dates, I would like the current value in cell C3 to populate the adjacent cell (B1) on the date specified in A1<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Ex: <o></o>
A1 = 8/11/11<o></o>
The value in C3 = 20<o></o>
On 8/11/11 whatever the current value is in C3 should copy into cell B1<o></o>
<o> </o>
Is there a formula I can write in column B that will pull this information automatically?<o></o>
<o> </o>
Thanks,

Allen

 

[VoG]

Sorry but this question is unclear, Please elaborate.

 

[Jonmo1]

Sure, try this in B1

=IF(TODAY()>=A1,C3,"")


Hope that helps.

 

[ultracyclist]

I tried the formula but its not returning any value in B1

 

[snoopyhr]

hmmm , maybe because it is not August 11 yet ? give it a time, it will work hehehehe unless you want to violate temporal directive

 

[ultracyclist]

Peter,

Let me know if this clarifies what I am looking to achieve

Column A contains the following dates starting on rows A1

8/11/11
8/22/11
9/5/11
9/20/11

Cell C3 contains the value 20. This number is generated from the sum of several cells and changes frequently.

On 8/11/11 it would enter 20 in to cell B1
On 8/22/11 it would enter what the current value is in C3 into cell B2

Somehow the formula needs to understand what the current date is in order to record this value.

If a macro is better suited for this type of automation I can use that as well.

Hope this helps.

Thanks

Allen

 

[ultracyclist]

Guess I missed that small detail. The formula works with the current date. As a test, I changed the date on my computer to 8/8/11, then changed the value in C3.

I have two dates listed in column A

8/5/11
8/8/11

When I ran the formula with the 8/8 date, it changed the value to the new value, but it also overwrote the value on the 8/5 date to be the same number.

Is there a way for it to retain the previous value? Essentially I should have a different value for each of the dates listed.

Thank you