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?
Date
Votes
2 comments
-
Chris Hey-- See if this works for you:
=(A2-2415018.5)-5/24 - DST
=(A2-2415018.5)-6/24 - NOT DST
Chris
-
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.