How to make my formula return blank value rather than "0"
Posted on 2011-03-09
I am using the following formula to automatically populate a spreadsheet with some default values.
However, in the above example if the value in Sheet1 is blank i.e an empty cell, excel returns 0/01/1900 as the result.
How can I get excel to return a blank cell rather than 0/01/1900?
Both the source and destination cell are formatted as "Date".