Date field when null

[ElaineWork]

Hi there,

I'm sure this is a very simple query. I'm using a formula to pickup a date field in a workbook created/updated by another user. Sometimes this field is blank and when it is picked up it is translated to a date field of 00/01/1900. I would like blank date fields to translate to blank, null or 00/00/00 date field..how can I do this?

 

[Scott Huish]

Hi, welcome to the board!

If it's just for display, you could custom format the cell as:
mm/dd/yyyy;;

 

[Richard Schollar]

Hi Elaine

Welcome to the Board!

You can probably use a simple IF statement:

=IF('C:\[MyFile.xls]Sheet1'!$A$1<1,"",'C:\[MyFile.xls]Sheet1'!$A$1)

changing the link reference to suit.

Hope this helps!

Richard

 

[Oaktree]

Welcome to the board.

Instead of =A1 (or similar) , try =IF(A1,A1,"")