Sunday, December 10, 2017

JDE Julian Date Converter in EXCEL Formulas

Formula to convert a date to JDE Julian date:
 =CONCAT(YEAR(A1)-1900,RIGHT(CONCAT("000",DAYS(A1,DATE(YEAR(A1),1,1))+1),3))

Formula to convert JDE Julian date to a normal date:
=DATE(LEFT(A1,3),1,1)+(RIGHT(A1,3)-1)

Posted by at
Labels: , , , , , , , , , , , , , , , , ,

1 comment:

  1. waelraccaMarch 4, 2022 at 3:48 PM

    Jumia Casino » Get Up to ₹2000 » Rs 8000 Bonus & 10 FS
    Jumia 과천 출장샵 is one of the biggest 서산 출장마사지 names in online betting. It has a large number of casino 양주 출장마사지 games and casino games including slots, table games, live  Rating: 속초 출장마사지 4 · ‎Review by 경기도 출장샵 TJ Houtfield

    ReplyDelete

Subscribe to: Post Comments (Atom)