I have Julian dates, all 7 dights like this one 2454525. I need to simply convert these in month/day/year.
Looked and looked but have found nothing relating to 7 digit date?
I have Julian dates, all 7 dights like this one 2454525. I need to simply convert these in month/day/year.
Looked and looked but have found nothing relating to 7 digit date?
=A1-2415018.5
Don't forget to format the cell as a Date.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks