Forum Discussion

nasirabd's avatar
nasirabd
Copper Contributor
Dec 13, 2021
Solved

Convert Date/Time String to Date Format

I am seeking assistance with converting a string that is a date/time value into a date format in Excel. I would like to use this field along with associated data in a pivot table to group by day, we...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 13, 2021

    nasirabd 

    You may convert text to date by formula like

    =DATE(
  RIGHT(A2,4),
  MONTH( 1&LEFT( RIGHT(A2,  LEN(A2) -4), 3) ),
  LEFT( RIGHT(A2,  LEN(A2) -8), 2))

    and apply to result any date format you wish.

Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Dec 13, 2021

nasirabd 

Select the date column and apply the format as per picture below:

CTRL+1 (Shortcut to access it)

 

  • nasirabd's avatar
    nasirabd
    Copper Contributor
    Dec 13, 2021

    Juliano-Petrukio 

     

    Thank you for your response. I did try using the custom date function in Format Cells and it did not make any changes.

Resources