Below is the formula that will remove the time from the date. Type a date in Cell A1 and in cell B1 type the formula EDATE4152013-5. This page lists the built-in Excel Date and Time Functions.
Ive downloaded a csv file that has a time on it but when its imported just looks like a number ie 1046 if I open the CSV in Excel and use a formula on it it shows as the decimal equivalent of the number is no longer the same time but rather a decimal representation of it and doesnt hold the 1046 i require this isnt then comparable.
This Excel date formula will calculate the number of days between two dates. There is a very simple formula that can quickly help you combine date column and time column into one. First we need to understand the working logic of date and time with excel. Its length is 8 bytes.