Forum Discussion

brendasc's avatar
brendasc
Copper Contributor
May 03, 2017

Converting to Date Format in Excel

I have a lengthly spreadsheet that lists a milestone date as follows:  201708 201709 201708 201711 201712 201709   I need to convert these to date format (August 2017 or 08/20...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 03, 2017

Hi,

 

Afraid that's only with helper column which you may format as date. If you dates are kept as numbers you may transfer them to dates for example like this

 

=DATE(A1/100,MOD(A1,100),1)

If that's text the approach is simular, just another formula.

  • brendasc's avatar
    brendasc
    Copper Contributor
    May 05, 2017

    Thanks for your response....but didn't work. I got this as a return value: #VALUE!

     

Resources