Solved

Convert YYYYMMDD date to Julian date in excel

Posted on 2014-09-12
3
856 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
Comment Utility
Julian format needs a four-digit year
0
 
LVL 6

Expert Comment

by:johnb25
Comment Utility
=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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

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…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now