Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Unanswered: Excel Date conversion

    How do I convert a cell with the following julian date format 'YYYYDOY' to a proper date format in Excel

  2. #2
    Join Date
    May 2009
    Posts
    258
    Considering the year as four digits and the day of year as three digits:
    Code:
    =DATE(LEFT(A2,4),0,RIGHT(A2,3))
    Regards,

    Ax

  3. #3
    Join Date
    Jul 2009
    Posts
    5
    Thanx Ax it works fine

  4. #4
    Join Date
    May 2009
    Posts
    258
    Excellent!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •