Thread
:
Convert Dates
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
external usenet poster
Posts: 2,886
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?
Reply With Quote
Roger Govier
View Public Profile
Find all posts by Roger Govier