Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Julian /Julienne Dates (97 sr2)

    ok. I don't know how to spell it. In addition to that, I don't know how to convert a regular date to a Julien date. Any ideas - spelling aside, please - I'm embarassed enough!

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Julian /Julienne Dates (97 sr2)

    See Chip Pearson's <A target="_blank" HREF=http://www.cpearson.com/excel/jdates.htm>Julian Dates</A>.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Julian /Julienne Dates (97 sr2)

    The formula below will convert the date in A1 to Julian:

    <pre>=TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,1)+1,"000")
    </pre>

    Legare Coleman

Posting Permissions

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