L Luis Felipe Alcantara May 7, 2006 #1 Hi, How change a julian date to "normal" date ? Tks advance, Luis Felipe
G Guest May 8, 2006 #3 Try this: For a Julian date in A1. Example: A1: 06127 B1: =("1/1/"&LEFT(A1,2))+RIGHT(A1,3)-1 In that example, B1 returns 38844 (May 7th, 2006) Note: Excel will engage it's default year logic in that formula to determine which century is used. 1900's vs 2000's Does that help? *********** Regards, Ron XL2002, WinXP-Pro
Try this: For a Julian date in A1. Example: A1: 06127 B1: =("1/1/"&LEFT(A1,2))+RIGHT(A1,3)-1 In that example, B1 returns 38844 (May 7th, 2006) Note: Excel will engage it's default year logic in that formula to determine which century is used. 1900's vs 2000's Does that help? *********** Regards, Ron XL2002, WinXP-Pro
G Guest May 8, 2006 #4 One more thing: If your Julian dates are numeric, Excel removes the leading zero. 06127 would become 6127 You can correct for that situation with this formula: B1: =("1/1/"&INT(A1/1000))+RIGHT(A1,3)-1 *********** Regards, Ron XL2002, WinXP-Pro
One more thing: If your Julian dates are numeric, Excel removes the leading zero. 06127 would become 6127 You can correct for that situation with this formula: B1: =("1/1/"&INT(A1/1000))+RIGHT(A1,3)-1 *********** Regards, Ron XL2002, WinXP-Pro
