Hi Rocky,I know this has to be simple. I want to return the date in a cell and if it's blank it returns nothing. The date is moving into thr cell for code so it is blank. Right now I get 1/0/0. Thanks
To be honest that still doesn't quite fit how I would expect it to work, however would it not be something like...OK the cell is blank until a code puts in a date. I used =Data!I4 but I get a 1/0/0 when the cell is empty. A code puts a date in and removes it later. I would like to see the date and nothing when the date is gone. Thanks
=IF(Data!I4, Data!I4, "")