|How about this:|
Format the cell with the formula as Date to display just the date.
If the time is from 6:00PM to 11:59PM, the HOUR will be greater than 17 (5PM) so add 1 to the date.
If the time is from 5:31PM to 5:59PM, the HOUR will equal 17 AND the MINUTE will be greater than 30, so add 1 to the date.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.