Browse » Home
Friday, February 24, 2012
How to Convert a Julian Date in Excel
1. Click on the cell were you would like your output data to start. For example, if you have a list of Julian dates in column A, you might want your regular dates to start on column B, so click on cell B1.
2. Enter the following formula into the cell. =('1/1/'(IF(LEFT(A2,2)*1
3. Copy the formula into as many cells as you want dates outputted. For example, if you have Julian dates in cells A1 through A50, copy the formula 50 times from cells B1 to B50.
4. Highlight the cells you created in Step 3.
5. Right-click on the highlighted cells and choose 'Format Cells.'
6. Click on 'Date' from the 'Number' tab. This tells Excel to convert the formula's output into regular calendar dates. Choose the date type (for example, 14 December, 2009 or 14 Dec) and click 'OK.'