| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Dates
How do you convert a Julian date with a 4 digit year into a standard calendar
date? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Converting Dates to 8 digits | Excel Worksheet Functions | |||
| How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd? | Excel Worksheet Functions | |||
| How to convert the dates from the YY:DD forma to MM/dd/YYYY format | Excel Worksheet Functions | |||
| Convert three separate columns of values to dates | Excel Worksheet Functions | |||
Linear Mode
