Date in IF Statement

[JTL9161]

I searched around but could not find my answer so I thought I would try here. It's probably something simple.

I am copying data from a spreadsheet listing to an invoice bill on another tab within the same spreadsheet.


Spreadsheet (Sheet1) has dates and payments. I am saying in the on the Invoice Tab (Sheet2)

=IF(Sheet1!A1="","",A1) which is saying if cell A1 does not have a date then leave it blank on the Invoice tab

but if cell A1 does have a date then show that date on the Invoice Tab.

When its blank it shows blank but when the date say 5/1/2016 the date shown on the Invoice tab is 1/0/1900

and I have the cell formatted for DATE mm/dd/yyyy.

Suggestions?

Thanks,
James

 

[robertdseals]

It doesn't look like you have a date in cell A1 of the Invoice tab. Are you perhaps trying to do this?
=IF(Sheet1!A1="","",Sheet1!A1)

 

[Dave Patton]

The cell A1 may be TEXT.
Try coercing the data to a number by adding 0 =IF(Sheet1!A1="","",A1+0)
If there are non-printing characters, review information on Excel's Clean and Trim.

As Robert mentioned, ensure that you are referencing the correct cell
=IF(Sheet1!A1="","",Sheet1!A1)

 

[JTL9161]

DOH! I knew I needed another set of eyes! Thanks.