Hide results

B

bigred72

I am putting together a summary spreadsheet of dates from seperate worksheets
in an excel file. In the summary sheet I reference the 'end' date from the
summary sheet. If there is no date in the original file, what formula can I
use to leave that cell blank/hide on the summary sheet? The way I have it
now the results show the default of 1/0/1900

Here is the formula used to reference the info from.

=Summary!K5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dumb question alert! What program to use? 0
Doughnut Chart linked with the slicer in the pivot table 0
Lookup based on list selection in cell 0
Help with an IF Statement 1
Populate Data from Summary Sheet 5
Excel found unreadable content in file error. 0
Summarise data from several worksheets in a workbook 2
Blank dates showing as 00 january 1900 - help 3

Top