Date issue
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 -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99763 |
Date issue
Use an IF statement
Suppose you want to display cell J1 only when it is not blank =IF(ISBLANK(J1),"",J1) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "willemeulen" wrote in message ... 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 -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99763 |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com