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
Bookmarks