Forum Discussion
Solved
drop the time from a date time field
I need to drop the time from an imported field that is date time. For example, the field imported as 1/26/2018 8:14:00 AM I need it to be only the date of 1/26/18 Is there a quick and easy formu...
If your dates are in column A. Just use this formula in a helper column then copy and paste values and delete the original column.
=TEXT(A2,"M/D/YYYY")
If imported data is recognized by Excel as date/time, not as text, you may simply format that column as date (not to show the time). And drop the time to the beginning of the date (if required) is =INT(<date>)
Thank you.
