Lets say I have four cell A1,A2,A3,A4

A1 contains a date(11/10/10 eg)

A2 contains $ data

A3 is blank

and in A4 I want a formula that asks =IF TODAY is equal to or greater than A1 then A3 is equal to A2 else blank (or 0)

Any help please