hi, i am looking to write a formula or macro that will look through column a for date values. For example if cell a2 has 05/05/10 and cell a3 is blank then cell a3 should look at last active cell, which would be a2 for any other calculations.

If somebody could please help. Thanks in advance.