Excel

[Suleman]

i am facing problem about that

Example :

i want that when A1 come to 3rd July 2008 that time C4=C4
its mean
as A1 come to the date of 3rd July that time the amount of cell B1 same
amount convert to the C1.

A1 B1 C1

22 rd july 86 .....

next day as the date update and A1 cell Come To 23rd july

A1 B1 C1
23 rd july 86 86

so thats it what i want i want as A1 come to required date data of B1
convert o C1

mean
B1=C1

 

[Bob I]

Please don't multi-post, please read the replies you already have.