Hi, dilipandey,
I got your point, Many thanks for helping me , it is something like 
B1=IF(A1="(blank)",TODAY()-1+TIME(23,59,0),A1)