Joanna

Bob and Roger supplied formulas.

If you do not want to deal with formulas use...

DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish.


Gord Dibben MS Excel MVP

On Fri, 8 Sep 2006 14:59:02 -0700, Jo Anna <Jo
wrote:

This formula did not work. I have a date of 20050609 for June 9, 2005 but
when I put in the formula it gave me this date: 8/31/2021

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/jdates.htm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jo Anna" <Jo wrote in message
...
How do you convert a Julian date with a 4 digit year into a standard
calendar
date?