1/0/1900 date in linked cell

[nooredein]

Hi,
happy new year

I have cells in "z" workbook linked to cells in "x" workbook.
each cell "in z" linked to "x" workbook cells to show expiry date of certain items

when a certain expiary date is missing or not ready "blank cell" in "x"workbook, the linked
cell in "z" workbook shows "1/0/1900"

I want your help to overcome this result and show the cell empty "ie, blank cell "as it is in the "x" workbook.

Wishes

[AliGW]

What is the formula you are using? Can you add an =IF(ISBLANK(x_cell_reference),"",...) to your formula?

[nooredein]

What is the formula you are using? Can you add an =IF(ISBLANK(x_cell_reference),"",...) to your formula?

I just use links =[x.xlsx]Sheet1!$E$7

How can I add this If formula?

[FDibbins]

the linked
cell in "z" workbook shows "1/0/1900"

That is actually showing 0 (zero), but in date format - it is saying that the cell is empty

[Pete_UK]

You can use this approach:

=IF([x.xlsx]Sheet1!$E$7="","",[x.xlsx]Sheet1!$E$7)

Another approach is to use the same formula that you have, but apply a Custom Format in that cell of:

M/D/YYYY;;

Note the two semicolons at the end of the format string - these cause zeros and negative numbers to be displayed as blanks.

Hope this helps.

Pete

[nooredein]

That is actually showing 0 (zero), but in date format - it is saying that the cell is empty

well, you might be right but this actually what happens in my sheet.
I think there is a trick and may be someone had the same problem and give a help.

why does this date appear as 1/0/1900, although it should appear blank?

[Pete_UK]

It seems that we posted at about the same time - see my Post #5.

Pete

[FDibbins]

why does this date appear as 1/0/1900, although it should appear blank?

Because the formatting is not telling it to, Pete's suggestion should fix that

[nooredein]

It seems that we posted at about the same time - see my Post #5.

Pete

thank you

I'll try it soon and give a feedback

[Pete_UK]

Thanks for the rep - I presume that means that it worked for you.

Pete