Forum Discussion

Alison Keith Elliott's avatar
Alison Keith Elliott
Copper Contributor
Jul 20, 2018
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 formula for this?

excel
Formulas and Functions
  • Matt Mickle's avatar
    Matt Mickle
    Jul 20, 2018

    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")

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 20, 2018

    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>)

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jul 20, 2018

    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")

Resources