Thread
:
convert Julian date
View Single Post
#
3
Ron Coderre
Posts: n/a
Try pointing this formula at your Julian Date:
I used Cell A1:
=DATE(1999+QUOTIENT(A1,1000),12,31)+MOD(A1,1000)
Does that help?
--
Regards,
Ron
Reply With Quote