Convert Dates
 

How do you convert a Julian date with a 4 digit year into a standard calendar
date?

Convert Dates
 

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?

Convert Dates
 

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?

Convert Dates
 

That is not a Julian date. You want

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

--

HTH

Bob Phillips

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

"Jo Anna" <Jo wrote in message
...
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?

Convert Dates
 

Hi Jo Anna

With your value in A1, try
=DATE(--LEFT(A1,4),--MID(A1,5,2),--(RIGHT(A1,2)))

What you have is not a Julian date, that is why the formula on Chip's
site does not work

--
Regards

Roger Govier


"Jo Anna" <Jo wrote in message
...
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?

Convert Dates
 

can you post your formula, so we can help better

"Jo Anna" wrote:

How do you convert a Julian date with a 4 digit year into a standard calendar
date?

Convert Dates
 

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?