G
Guest
How do you convert a Julian date with a 4 digit year into a standard calendar
date?
date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
See http://www.cpearson.com/excel/jdates.htm
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
B
Bob Phillips
See http://www.cpearson.com/excel/jdates.htm
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
G
Guest
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
when I put in the formula it gave me this date: 8/31/2021
G
Guest
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
when I put in the formula it gave me this date: 8/31/2021
B
Bob Phillips
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)
=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)
B
Bob Phillips
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)
=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)
R
Roger Govier
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
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
R
Roger Govier
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
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
G
Guest
can you post your formula, so we can help better
G
Guest
can you post your formula, so we can help better
G
Gord Dibben
Joanna
Bob and Roger supplied formulas.
If you do not want to deal with formulas use...
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish.
Gord Dibben MS Excel MVP
Bob and Roger supplied formulas.
If you do not want to deal with formulas use...
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish.
Gord Dibben MS Excel MVP
G
Gord Dibben
Joanna
Bob and Roger supplied formulas.
If you do not want to deal with formulas use...
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish.
Gord Dibben MS Excel MVP
Bob and Roger supplied formulas.
If you do not want to deal with formulas use...
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish.
Gord Dibben MS Excel MVP