Hi all,

Need some help, how can i convert "Date and Time " format in a column to reflect only "Date". ( through VBA )

eg, 11/23/2018 8:28:14 AM

should get converted to

11/23/2018

Date and time format is available in "B" column, so i need code to convert this in to date in the specific column.