Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Issue | Excel Discussion (Misc queries) | |||
Date Issue | Excel Discussion (Misc queries) | |||
Date issue | Excel Worksheet Functions | |||
DATE ISSUE! | Excel Worksheet Functions | |||
Date issue | Excel Worksheet Functions |