Ok this is one of those one that is probably so simple I've overlooking the obvious solution.

I have two sheets, on sheet one in A1 I have 09/12/2005

On sheet two in cell B1 I would like to use a formula (or anything that will work) that looks at cell A1 on sheet 1 and then formats it to read,

>=09/12/2005

I've tried =IF(Sheet1!A1>1,">=Sheet1!A1") but this just left the cell to read,

>=Sheet1!A1

Which doesn't work when I try and apply a advanced filter.

Thanks for any help in advance.
AU