Datevalue+timevalue returns "the cell currently being evaluated contains a constant"

Hello guys,   I would like to receive some help from you, as i cannot understand why my formula works for some values and for others isn't.   So, in date1 column, i have a formula applied t...