Solved

Convert YYYYMMDD date to Julian date in excel

Posted on 2014-09-12
3
906 Views
Last Modified: 2014-09-12
how do I convert a YYYYMMDD date to a Julian date in excel?  or maybe I should say  Julian Day Number (JDN), YYYYJJJ.
0
Comment
Question by:roosterup
  • 2
3 Comments
 
LVL 1

Author Comment

by:roosterup
ID: 40319248
Julian format needs a four-digit year
0
 
LVL 6

Expert Comment

by:johnb25
ID: 40319302
=LEFT(A1,4)&DAYS(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),DATE(LEFT(A1,4),1,1))
If your original date is in A1.

John
0
 
LVL 6

Accepted Solution

by:
johnb25 earned 500 total points
ID: 40319310
Sorry, need to +1...the Days formula calculates the days between two dates
=LEFT(A1,4)&DAYS(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),DATE(LEFT(A1,4),1,1))+1
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

774 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question