• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1159
  • Last Modified:

Convert YYYYMMDD date to Julian date in excel

how do I convert a YYYYMMDD date to a Julian date in excel?  or maybe I should say  Julian Day Number (JDN), YYYYJJJ.
0
roosterup
Asked:
roosterup
  • 2
1 Solution
 
roosterupAuthor Commented:
Julian format needs a four-digit year
0
 
johnb25Commented:
=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
 
johnb25Commented:
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now