Forum Discussion
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...
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.
Thanks for your response....but didn't work. I got this as a return value: #VALUE!