I am linking one cell, in an Excel (2000) sheet to another cell, in another sheet, within the same workbook. I have formatted them for date. How can I keep the ‘receiving cell’ clear, until I enter a date into the Primary cell?
Thanks