Date issue

W

willemeulen

On sheet1 I complete all info displayed spread over other sheets of
which many information is repeated. So I have a direct reference to
sheet1 and only need to complete this information once. My problem is
with the dates for revisions. I only complete a date for the revision
when there is actually one

Sheet 1
Revision No. Issued
1 mar 09
2 apr 09
3
4
etc

When i reference date's directly to empty cells, in this case like for
revision 3 is not done (could or could not be done at a later stage) so
the cell is empty. Now all referenced cells display jan 00, how do I get
around it to let excel display nothing and only show a date when I
actually submitted a date in the mother cell.


Thanks
 
B

Bernard Liengme

Use an IF statement
Suppose you want to display cell J1 only when it is not blank
=IF(ISBLANK(J1),"",J1)
best wishes
 

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

Top