Hi all,

I've got an issue where I need a formula that when I put a date (or any
value) in cell A1, the text 'Closed' is automatically entered in cell B1
- I'm sure I've seen it somewhere before (probably used it too), but
I've searched in vain - can anyone help?

TIA


Dave