As advised don't use ROUND use INT to extract the date of the datetime value given the former will actually increase the day by 1 whenever the time portion of the datetime value is greater than or equal to noon.

Consider: X is 39944.5 (11th May Noon)

ROUND(X,0) --> 39945 --> 12th May
INT(X) --> 39944 --> 11th May