View Single Post
  #1   Report Post  
Ron
 
Posts: n/a
Default how to convert julian date to regular calendar date

I need help converting Julian Date to regular calendar date.
I have from 5000 €“ 10000 Julian Dates in one column. Ex.
Col A need converted to
4001 = 1 Jan 04
5001 = 1 Jan 05
5030 = 30 Jan 05

Any help would be much appreciated.
Thanks
Ron

--
Ron