IF formula help

[asabur6]

I need a formula that shows:

if todays date(C4) is before or on the specified date, then insert whats in B5, otherwise (or if todays date is after specified date) insert/keep what shows in B5 on that specified date.
I have so far:
=IF(C4<=DATE(2012,9,28),$B$5)

The point is that B5 will constantly be changing, If I dont specify what to do after specified date, then the result shows FALSE.

I hope I made sense! Much appreciated

[vlady]

isn't that your just getting the same information that is B5

=IF(C4<=DATE(2012,9,28),$B$5,B5)

nsert/keep what shows in B5 on that specified date.

or better

=$B$5

[asabur6]

the amount in B5 is constantly changing. so for instance on 9/28/2012 B5 will be $400. On 9/29/2012 B5 might be $350. I want to keep the $400 thats shown in B5 on 9/28, on 9/29 and thereafter.

[vlady]

i think that can only be attained by vba.

not my line..
maybe someone can help you with tis, just wait. ok. thanks.