Date issue-displaying as 0001-01-01

  • Thread starter Thread starter Tasha
  • Start date Start date
T

Tasha

I have imported a file that is system generated from our IBM server, so can't
change it on that side. The records that don't have a date come across as
0001-01-01. I need to know if there is a way to format these cells to
display as blanks if it contains this. Hope someone can help....have
searched and searched and haven't been successful in finding anything?
 
ok, got the formula below to work, is that right, or is there a way to
shorten it?

=IF(VLOOKUP($A3,'census file'!$B$2:$F$572,5,FALSE)="0001-01-01","
",VLOOKUP($A3,'census file'!$B$2:$F$572,5,FALSE))
 
Looks good to me. Essentially, you are looking up the value in $A3 on your
census file tab table $B$2:$F$572, and if the 5th column of that table for
the $A3 reference is "0001-01-01" then show nothing, otherwise display what
is there.
 
Ok :) thanks John!!!

John C said:
Looks good to me. Essentially, you are looking up the value in $A3 on your
census file tab table $B$2:$F$572, and if the 5th column of that table for
the $A3 reference is "0001-01-01" then show nothing, otherwise display what
is there.
 
Your formula broke at a bad spot.

I wouldn't use: ," ",
I'd use: ,"",

No reason to put an extra space character in the cell.
 
Thanks Dave, I took the extra space out.....

Dave Peterson said:
Your formula broke at a bad spot.

I wouldn't use: ," ",
I'd use: ,"",

No reason to put an extra space character in the cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top