Copy Cells using IF for non -blank values

I have a table where there are 3 columns which have blanks in them . I want to copy the non blank values to suppose D2. Say I have blank in C2 , B2 is not blank , then the value to be copied is B2 . If both C2 and B2 are blank , then value to be copied is A2. I am using the following formula:

=IF(C2="",B2,IF(B2="",A2, C2))

It is running correctly for the values where C2/B2 values are blank . But it throws up a 00-01-1900 Value in D2 when both the C2 and B2 cells are blank and I want only A2 data in the cell . Is there some way to resolve this ?