New post
0

Exporting observations

When I export observations to CSV format the output is for the Julian date in a very long format that also includes time but I need a formula to convert the left column of Julian dates into an adjacent column of standard day-month-year format. Can someone please provide this or suggest another solution?

2 comments

  • 0
    Avatar
    Chris

    Hey-- See if this works for you:

     

    =(A2-2415018.5)-5/24 - DST

     

    =(A2-2415018.5)-6/24 - NOT DST

     

    Chris

  • 0
    Avatar
    Nfolberg

    Wow - magic, it works! So easy when you know how. Thanks a lot Chris, now I have access to all of my observations sorted by date.

Please sign in to leave a comment.