I’ve recently combined three spreadsheets into a five-spreadsheet file. Three of the spreadsheets are the three original spreadsheets, the last is one that I made to keep stuff that was at the bottom of those, and which I wanted to move so that I could sort the other pages easier, and the first page is a reformatted combination of the original three spreadsheets.
Since I don’t want to enter dates in one or two places twice, sheet 1 draws the dates from the fields in the other sheets. (i.e., I type ‘=’ and click on the appropriate cell on the other sheet.) The dates on all pages are formatted as mm/dd/yy. On the original sheets the cells are blank when there is no date. On the first sheet, the one that draws the dates from the other ones, blank dates show up as 01/00/00.
How do I make the blank dates appear blank on sheet 1?