Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates linked in Excel files
Microsoft Excel 2007: If there are cells in the original worksheet (file)
that contain dates and other cells that are "date" formatted; however, no dates have been entered, how can I show a "blank" cell on the worksheet of the linked file? Currently, if the date formatted cell is blank on the original file, the second file is auto filled with the date of 1/10/1900. I need the linked worksheet to show blank cells until an actual date is entered in the cells of the original file. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates linked in Excel files
Do an isblank formula. Where Date1 is where you want to show the linked
values and Date2 is your source, type in Date1 sheet: =IF(ISBLANK(Date2!A1),"",Date2!A1) "JayDee" wrote: Microsoft Excel 2007: If there are cells in the original worksheet (file) that contain dates and other cells that are "date" formatted; however, no dates have been entered, how can I show a "blank" cell on the worksheet of the linked file? Currently, if the date formatted cell is blank on the original file, the second file is auto filled with the date of 1/10/1900. I need the linked worksheet to show blank cells until an actual date is entered in the cells of the original file. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates linked in Excel files
=IF('other sheet'!A2="","",'other sheet'!A2)
HTH Kostis Vezerides On Jun 27, 7:04 pm, JayDee wrote: Microsoft Excel 2007: If there are cells in the original worksheet (file) that contain dates and other cells that are "date" formatted; however, no dates have been entered, how can I show a "blank" cell on the worksheet of the linked file? Currently, if the date formatted cell is blank on the original file, the second file is auto filled with the date of 1/10/1900. I need the linked worksheet to show blank cells until an actual date is entered in the cells of the original file. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates linked in Excel files
You could do it like this:
=IF(Sheet1!A1="","",Sheet1!A1) will display a blank if the "sending" cell is blank. Hope this helps. Pete On Jun 27, 5:04*pm, JayDee wrote: Microsoft Excel 2007: *If there are cells in the original worksheet (file) that contain dates and other cells that are "date" formatted; however, no dates have been entered, how can I show a "blank" cell on the worksheet of the linked file? *Currently, if the date formatted cell is blank on the original file, the second file is auto filled with the date of 1/10/1900. *I need the linked worksheet to show blank cells until an actual date is entered in the cells of the original file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to save versions of multiple linked excel files? | Excel Discussion (Misc queries) | |||
Linked Excel files change size when updated | Excel Discussion (Misc queries) | |||
Copying linked Excel Files | Excel Discussion (Misc queries) | |||
How to save values only from linked Excel files? | Excel Discussion (Misc queries) | |||
Moving linked Excel/Access files to another machine | Links and Linking in Excel |