this should also work

=IF(A2=DATEVALUE("1/8/2014"),"Existing",IF(A2<DATEVALUE("1/8/2014"),"Out of Date",IF(A2>DATEVALUE("1/9/2014"),"Upcoming")))