Search code examples
exceldatetimeexcel-formulaworksheet-functionopenoffice.org

Formula to change 'year''number of days' into mm-dd-year

I currently was able to split apart a Landsat image for the date information where it was LC80440142014093LGN00.tar.gz, and I got it split into 2014093. Now I need to change that into a date in Excel or Open Office.

So I currently have a number 2014093, I need to change that into a date format that should be like this April 4, 2014.

Solution

  • In Excel please try: 

    =DATE(LEFT(A1,4),1,RIGHT(A1,3))