| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link a date between two worksheets.
I am trying to link a date from one wooksheet to another, using the same
workbook. For the cells in workbook A that are blank, I want them to show up on workbook B as blank. However, when I try to link the blank cell in A, I am getting a date format (1/1/00) in cell B. Any ideas? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link a date between two worksheets.
=if(a1="","",a1)
=if(sheet2!a1="","",sheet2!a1) Caterpillar wrote: I am trying to link a date from one wooksheet to another, using the same workbook. For the cells in workbook A that are blank, I want them to show up on workbook B as blank. However, when I try to link the blank cell in A, I am getting a date format (1/1/00) in cell B. Any ideas? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link rows in different worksheets? | Excel Worksheet Functions | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions | |||
Hybrid Mode
